🚀 go-pugleaf

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