🚀 go-pugleaf

Maybe,  but the code seems to work okay for me

Jonny

"Viatcheslav V. Vassiliev" <support@oledbdirect.com> wrote in message
news:3e6e15fa$1@newsgroups.borland.com...
> Requery re-executes command and fetches all rows again. So bookmarks
become
> invalid. You may try primary key, save its value before requery and locate
> it after.
>
>
> ----------------------------------------------------------------
> Regards,
> Viatcheslav V. Vassiliev
> http://www.oledbdirect.com
> The fastest way to access MS SQL Server, MS Jet (MS Access)
> and Interbase (through OLEDB) databases.
>
> "Jonny" <jonny@nospam.jonnywilk.co.uk> �������/�������� � ��������
> ���������: news:3e6dac14$1@newsgroups.borland.com...
> > I too had this problem
> >
> > I overcame it by using the requery() method on the ADOTable - however,
> this
> > would loose my place in the database so i used a bookmark to save it..
The
> > code looked a little bit like this:
> >
> > void TForm1::DB_Refresh()
> > {
> >  TBookmark SavePlace;
> >  TExecuteOptions myOptions;
> >  myOptions << eoAsyncFetch ;
> >
> >  // get a bookmark so that we can return to the same record
> >  SavePlace = ADOTable1->GetBookmark();
> >  // Re run the query
> >  ADOTable1->Requery(myOptions);
> >  // Now return to where we were before
> >  ADOTable1->GotoBookmark(SavePlace);
> >  ADOTable1->FreeBookmark(SavePlace);
> > }
> >
> >
> >
> > Jonathan
> >
> >
> > "Viatcheslav V. Vassiliev" <support@oledbdirect.com> wrote in message
> > news:3e684296@newsgroups.borland.com...
> > > You can do this on client-side cursor with LockType =
ltBatchOptimistic.
> > In
> > > this mode ADO caches data, updates, inserts, deletes etc. Look help
for
> > > FilterGroup property.
> > >
> > > ----------------------------------------------------------------
> > > Regards,
> > > Viatcheslav V. Vassiliev
> > > http://www.oledbdirect.com
> > > The fastest way to access MS SQL Server, MS Jet (MS Access)
> > > and Interbase (through OLEDB) databases.
> > >
> > > "NEO" <glin@gri-china.com> �������/�������� � �������� ���������:
> > > news:3e683f38@newsgroups.borland.com...
> > > > for example , any changes made in MS Office Word is going to be
> recorded
> > ,
> > > > and promots you before you exit without save.
> > > >
> > > > Does ADOQuery have any property or method to do the same thing?
> > > >
> > > > this matter has put me in the jam so long time.
> > > >
> > > > Thanks
> > > > neo
> > > >
> > > >
> > >
> > >
> >
> >
>
>