Article View: borland.public.cppbuilder.database.ado
Article #3633Re: Updating datasets
From: Ronald Loonstra
Date: Mon, 22 Jul 2002 21:30
Date: Mon, 22 Jul 2002 21:30
44 lines
1966 bytes
1966 bytes
Leen,
I assume you have opened the other ADODataSets before you added the records
in the first ADODataSet?
An opened ADODataSet only contains the records which were available when you
opened it (In other words, the moment you executed the query). You can get
the actual records with ADODataSet->Requery().
Maybe this helps.
--
HTH
Ronald Loonstra
CodeFit Applications
www.codefit.nl
"Uros Obradovic" <ouros@hotmail.com> schreef in bericht
news:3d35b0b3$1_2@dnews...
> I'd rather say its better if you update tables.
> Lets say you have ADOTable1, ADOTable2, try to do something like this
>
> ADOTable1->Open();
> ADOTable1->Edit();
> ADOTable1->FieldByName("the_name_of_the_field")->AsString = DBEdit1->Text;
> .
> ..
> ADOTable2->Open();
> ADOTable2->Edit();
> ADOTable2->FieldByName("the_name_of_the_field")->AsInteger =
DBEdit5->Text;
> .
> ..
> ADOTable1->Post();
> ADOTable2->Post();
>
> this is all you gotta put and it should work.
> i tried to work w/ datasets but i found this way easier for me.
>
> Good luck
> Uros
>
>
Technical Details
Message-ID:
<3d3c7817_2@dnews>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!sn-xit-04!supernews.com!newspump.sol.net!news.maxwell.syr.edu!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!dnewsReferences:
<3d33dadd$1_2@dnews> <3d35b0b3$1_2@dnews>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,d95cd720df6e47c X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2002-07-22 14:46:09 PST From: "Ronald Loonstra" <r.loonstra@codefit.nl> Newsgroups: borland.public.cppbuilder.database.ado References: <3d33dadd$1_2@dnews> <3d35b0b3$1_2@dnews> Subject: Re: Updating datasets Date: Mon, 22 Jul 2002 23:30:10 +0200 Lines: 46 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 NNTP-Posting-Host: 217.121.245.5 Message-ID: <3d3c7817_2@dnews> X-Trace: dnews 1027373079 217.121.245.5 (22 Jul 2002 14:24:39 -0700) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!sn-xit-04!supernews.com!newspump.sol.net!news.maxwell.syr.edu!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!dnews