I'm just working on a data-entry screen for some header/detail data, at
present I load the dataset into a RXMemory table, and upon hitting save, I
delete the existing data and insert the modifed data with multiple INSERT
statements wrapped with a transaction (slow as hell on larger datasets),
this was initially done when I wasn't using a DBGrid control (was looking at
spread sheet components).
Now that I've switched to using a DBGrid, I'm reworking how I'm updating the
underlying table, and I was just wondering what the best way to handle this
is, (the database is paradox/bde with Delphi 5 Pro)...
http://www.wibble.net/~naked/snap.gif (simple shot of edit form)
I was going to look at using TQuery/TUpdateQuery as it works, but I remember
reading numerous threads here in the past about how 'bad' they are and how I
should be using TClientDataset (not available in Pro thou). What is the
best way I should handle this? Should I just go ahead and use the
TUpdateQuery or is there a better way?
Mark
--
Inspired by the taste of horror, proud to be insane forever
Let out the killer in me! (c) Dismal Euphony
Now Playing: Lynch Mob - Get It Together
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
