🚀 go-pugleaf

At some point, the code will stop working with a "bookmark invalid" message.
The same thing happens if you save a bookmark, then close and reopen a
dataset - that makes the bookmarks invalid.  You might be lucky in that the
bookmark still works, but that's just chance.

"Jonny" <jonny@nospam.jonnywilk.co.uk> wrote in message
news:3e70689b@newsgroups.borland.com...
> 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
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>