Page 1 of 1

Create queries like TDataprovider in Delphi

Posted: Tue 25 Nov 2008 11:20
by jkuiper
I read in this forum that I can use TMyLoader to put my virtual records in the real table (Mysql). Is this simular to TClientdataset --> TDataprovider --> TQuery? When using TClientdataset.applyupdates(), the dataprovider creates queries for insert /update / delete.

Posted: Wed 26 Nov 2008 08:27
by Plash
Yes, the TMyLoader component creates INSERT statement to add data to the database table.

Posted: Thu 27 Nov 2008 12:10
by jkuiper
But no update and delete queries :(

Posted: Fri 28 Nov 2008 12:40
by Plash
You should use the TMyQuery component in CachedUpdates mode instead of TVirtualTable if you want to INSERT, UPDATE, and DELETE statements to be generated.