Robert, The data comes from a THttpCli component as XML about every two minutes. The XML is transformed to a dataset and the data then put into the first ClientDataSet. After it is processed and the unwanted data removed, then the second clientdataSet controls are disabled, the remaining data from the first ClientDataSet is added to the second ClientDataSet, and the controls reenabled.
For now, I am just doing an append, and then looping through the fields and editing them to put the correct values in. But that seems quite inelegant. If there is a way to get the TVarRec for each record from the first ClientDataSet then that would be preferred. Both methods will adjust to changes in the fields, but using the TVarRec seems to be the most elegant way to do it. Sincerely, Brad Gies ------------------------------------- NLM Software Southfield, MI, USA ------------------------------------- > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:delphi-talk- > [EMAIL PROTECTED] On Behalf Of Robert Meek > Sent: Tuesday, October 11, 2005 5:56 AM > To: 'Delphi-Talk Discussion List' > Subject: RE: TVarRec > > 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:delphi-talk- > [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 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
