Create queries like TDataprovider in Delphi

jkuiper · Post by **jkuiper** » Tue 25 Nov 2008 11:20

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.

Plash · Post by **Plash** » Wed 26 Nov 2008 08:27

Yes, the TMyLoader component creates INSERT statement to add data to the database table.

jkuiper · Post by **jkuiper** » Thu 27 Nov 2008 12:10

But no update and delete queries

Plash · Post by **Plash** » Fri 28 Nov 2008 12:40

You should use the TMyQuery component in CachedUpdates mode instead of TVirtualTable if you want to INSERT, UPDATE, and DELETE statements to be generated.