🚀 go-pugleaf

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
> > >
> > >
> >
> >
>
>