Create queries like TDataprovider in Delphi

Create queries like TDataprovider in Delphi

Postby 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.
jkuiper
 
Posts: 138
Joined: Fri 04 Aug 2006 14:17

Postby Plash » Wed 26 Nov 2008 08:27

Yes, the TMyLoader component creates INSERT statement to add data to the database table.
Plash
Devart Team
 
Posts: 2844
Joined: Wed 10 May 2006 07:09

Postby jkuiper » Thu 27 Nov 2008 12:10

But no update and delete queries :(
jkuiper
 
Posts: 138
Joined: Fri 04 Aug 2006 14:17

Postby 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.
Plash
Devart Team
 
Posts: 2844
Joined: Wed 10 May 2006 07:09


Return to VirtualDAC