>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.
>
It is a little bit out of topic but I am very curious about it.
What in case of NATIVE datasource type - is it possible to close underlaying VFP table after filling cursor and open it just before tableupdate. In this case we exactly know "connection".
Can such way of work increase stability of VFP database (table coruption problem) ?
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