#1 2011-04-23 22:29:03

dzh2000
Member
Registered: 2011-04-23
Posts: 2

I search for an example with TSQLTable

Thank you

Offline

#2 2011-04-24 09:04:14

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.

Offline

#3 2011-04-24 15:20:19

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)

Offline

#4 2011-04-24 19:01:06

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 14,603
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.

Offline

Board footer

Powered by FluxBB