ClientDataSet & modified records

Article View: borland.public.cppbuilder.database.ado

Article #2267

Back to borland.public.cppbuilder.database.ado Previous Next

#2267

From: newbie
Date: Mon, 22 Sep 2003 21:55

21 lines
1446 bytes

Hello all,


I am using a TCLientDataSet connected to a DBGrid, so that I can edit the data without modifing the database directly.

Is there a means of determining which records were modified (insert\delete\edit)?
I tried using ->Delta but had no success!


 I need to iterate through the clientdataset and manually perform the insert\update and delete queries. I beleave I need to do this manually because the clientdataset'a SQL joins several tables, some of which are lookup tables.


If anyone has any suggestions or advice feel free!!

thanks,


newbie

p.s using BCB6

Technical Details

Message-ID: <3f6f6fc6@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!newsfeed.wirehub.nl!news.kweb.on.ca!KWeb!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,ba26b23c56059862,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-09-22 15:01:37 PST
From: "newbie" <ms_crack@yahoo.com>
Sender: "newbie" <ms_crack@yahoo.com>
Reply-To: "newbie" <ms_crack@yahoo.com>
Subject: ClientDataSet & modified records
Newsgroups: borland.public.cppbuilder.database.ado
X-User-Info: 138.11.254.204 138.11.254.204    
X-Forwarded-For: 192.168.151.203
NNTP-Posting-Host: 207.105.83.65
Message-ID: <3f6f6fc6@newsgroups.borland.com>
Date: 22 Sep 2003 14:55:18 -0700
X-Trace: newsgroups.borland.com 1064267718 207.105.83.65 (22 Sep 2003 14:55:18 -0700)
Lines: 21
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!newsfeed.wirehub.nl!news.kweb.on.ca!KWeb!newsgroups.borland.com!not-for-mail