Article View: borland.public.cppbuilder.database.ado
Article #3639Re: Updating datasets
From: Leen
Date: Tue, 23 Jul 2002 07:27
Date: Tue, 23 Jul 2002 07:27
59 lines
2469 bytes
2469 bytes
Hey,
No, it doesn't seems to work. It's strange. The first record I add isn't
displayed in other datasets, but all the records I add afterwards, are
displayed in other datasets! Does a dataset work with buffers? How can I
solve this?
Thanks!
"Ronald Loonstra" <r.loonstra@codefit.nl> schreef in bericht
news:3d3c7817_2@dnews...
> 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:
<3d3d0560_1@dnews>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-04!supernews.com!iad-peer.news.verio.net!news.verio.net!news.maxwell.syr.edu!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnewsReferences:
<3d33dadd$1_2@dnews> <3d35b0b3$1_2@dnews> <3d3c7817_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-23 00:33:35 PST Reply-To: "Leen" <Leen.VanHaecke@entropia.be> From: "Leen" <Leen.VanHaecke@entropia.be> Newsgroups: borland.public.cppbuilder.database.ado References: <3d33dadd$1_2@dnews> <3d35b0b3$1_2@dnews> <3d3c7817_2@dnews> Subject: Re: Updating datasets Date: Tue, 23 Jul 2002 09:27:58 +0200 Lines: 61 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 NNTP-Posting-Host: 212.100.179.241 Message-ID: <3d3d0560_1@dnews> X-Trace: dnews 1027409248 212.100.179.241 (23 Jul 2002 00:27:28 -0700) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-04!supernews.com!iad-peer.news.verio.net!news.verio.net!news.maxwell.syr.edu!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews