🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: Updating datasets

#3652
From: Ronald Loonstra
Date: Wed, 24 Jul 2002 17:40
105 lines
3881 bytes
Leen and Mr. Vassiliev,

This problem reminds me of a problem I had in the past (and I guess still
have) which only affects the -first- append. When, after the dataset is
opened, the first action executed is an append the cursor moves to the last
record instead of appending a new record.

Is this maybe a known bug in Jet OLEDB?

HTH

Ronald Loonstra
CodeFit Applications
www.codefit.nl

"Leen" <Leen.VanHaecke@entropia.be> schreef in bericht
news:3d3e5187$1_2@dnews...
> No,
>
> I didn't do anything like that.
> "Vassiliev V.V." <news@vassilievvv.mtu-net.ru> schreef in bericht
> news:3d3e42b9_2@dnews...
> > Check that you do not change pointer to dataset (something like
> ADODataSet2
> > = ADODataSet1).
> >
> > Regards,
> > Vassiliev V.V.
> > http://www.oledbdirect.com
> >
> >
> > "Leen" <Leen.VanHaecke@entropia.be> �������/�������� � ��������
���������:
> > news:3d3d0560_1@dnews...
> > > 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: <3d3ee53b_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!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!dnews
References: <3d33dadd$1_2@dnews> <3d35b0b3$1_2@dnews> <3d3c7817_2@dnews> <3d3d0560_1@dnews> <3d3e42b9_2@dnews> <3d3e5187$1_2@dnews>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII
X-Google-Thread: 10698b,d95cd720df6e47c
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-07-24 10:42:41 PST
From: "Ronald Loonstra" <r.loonstra@codefit.nl>
Newsgroups: borland.public.cppbuilder.database.ado
References: <3d33dadd$1_2@dnews> <3d35b0b3$1_2@dnews> <3d3c7817_2@dnews> <3d3d0560_1@dnews> <3d3e42b9_2@dnews> <3d3e5187$1_2@dnews>
Subject: Re: Updating datasets
Date: Wed, 24 Jul 2002 19:40:25 +0200
Lines: 107
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: <3d3ee53b_1@dnews>
X-Trace: dnews 1027532091 217.121.245.5 (24 Jul 2002 10:34:51 -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!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!dnews