mORMot Open Source

dzh2000

Member

Registered: 2011-04-23

Posts: 2

I search for an example with TSQLTable

Thank you

array81

Member

From: Italy

Registered: 2010-07-23

Posts: 411

Re: I search for an example with TSQLTable

I think you should get more details.

dzh2000

Member

Registered: 2011-04-23

Posts: 2

Re: I search for an example with TSQLTable

It is necessary to open local database and to select the data on a certain condition. Also it is necessary to change the data.
Such simple example isn't present.
I understand that TSQLDatabase and TSQLTable are required, but I do not know how to use.

Last edited by dzh2000 (2011-04-24 15:30:12)

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,269

Website

Re: I search for an example with TSQLTable

About those classes, I just wrote a whole dedicated part in the updated documentation of the framework (to be released in the 1.13 version, and already available in the Source code repository as .pro source file).

But the main feature to understand is that it's ORM based: that is, you should use Delphi classes to list then modify the data.
You define TSQLRecord types, then use Add/Retrieve/Delete/Update methods of a TSQLRestClient, then use FillPrepare then FillOne methods of TSQLRecord to retrieve the needed data.
There is no benefit of using directly a TSQLTable or TSQLDatabase classses.