I assume your issue is speed. I know nothing about RXMemory tables - but how
about a BatchMove - batAppend from your memory table back into your
database.. They're usually pretty quick.
----- Original Message -----
From: "Derricutt, Mark" <[EMAIL PROTECTED]>
To: "Multiple recipients of list database" <[EMAIL PROTECTED]>
Sent: Tuesday, August 08, 2000 2:27 PM
Subject: [DUG-DB]: Updating a database from a query dataset...
> 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
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
