Hi Mark,
>I made a typing error. TABLEUPDATE doesn't work, nowever TABLEREVERT does. I have tested this over and over again.
>
REQUERY uses exactly the same DataSourceType and DataSource that CursorFill used to create the cursor.
TABLEUPDATE uses current settings for the CursorAdapter.
TABLEREVERT doesn't use DataSource, it simply throws buffered changes away.
It is possible to reconnect for TABLEUPDATE using Before* events, but to make REQUERY work for ODBC, you have to reconnect exactly the same connection handle - very hard to accomplish manually.
I believe all you need to do is to set SQLSETPROP(...,"IdleTimeout",...) and VFP will do all work for you, it will automatically disconnect and reconnect the connection handle.
Thanks,
Aleksey.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement