>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) ?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only