I only started with dB apps last year so if this sounds dumb please
forgive me, but it seems to me that you're doing a lot of redundant work!
If I understood you correctly wouldn't it be better to use a query, or for
that matter just update a read-only view of the original, 1st table! Also,
it didn't sound like it, but if the same user viewing the filtered data also
does inputs, then use an in-memory table and update the original table from
it. If and when it accepts the changes, the view is again updated.
You also didn't say if there would be edits and/or deletes along
with the appends. Either way though if you use a two table system like you
described, what do you plan on doing during the batch append? Are you going
to suspend the second table's updates? You didn't tell the source of the
original appends either. /Are they going to be from one source? On the
same machine? On a server, or from multiple users? All these things can
affect the design as you know. Another thing to think about with
ClientDataSets is that you can save their data out to a dat or xml file. So
depending upon the average number of changes per update, it might be easier
to simply save the original table out to a file and then load that file in
the second!
from: Robert Meek at: [EMAIL PROTECTED]
dba "Tangentals Design" home of "PoBoy"
freeware Windows apps and utilities
located at: www.TangentalsDesign.com
Proud to be a moderator for the
"Delphi Programming Lists" at: elists.org
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Gies,Brad
Sent: Monday, October 10, 2005 6:14 PM
To: Delphi-Talk Discussion List
Subject: TVarRec
I have two ClientDataSets with identical fields. One is for the user
viewing the data, and the second receives incoming data, processes it,
filters out unwanted records and then adds the remaining records to the
other ClientDataSet so the user can view them.
I would like to do this by using the AppendRecord method, which takes a
TVarRec array of the values, but I don't want to have to list every
field (there are 89 fields and that could change), so does anyone know
how I get the TVarRec from the first ClientDataSet, so I can use it in
the AppendRecord method of the second ClientDataSet?
Any help appreciated.
Sincerely,
Brad Gies
-------------------------------------
NLM Software
Southfield, MI, USA
-------------------------------------
This e-mail is intended only for the person or entity to which it is
addressed and may
contain confidential and/or privileged material. Any review,
retransmission,
dissemination or other use of, or taking of any action in reliance upon,
this information
by persons or entities other than the intended recipient is prohibited. If
you
received this message in error, please contact the sender immediately and
delete
the material from your computer.
__________________________________________________
Delphi-Talk mailing list -> [email protected]
http://www.elists.org/mailman/listinfo/delphi-talk
__________________________________________________
Delphi-Talk mailing list -> [email protected]
http://www.elists.org/mailman/listinfo/delphi-talk
