Hi,
I have a small problem with a Refresh() command not working with a remote view of a VFP database through ODBC.
The vfp database contains two layers -- the base tables and a view over the top. The remote view is of the top level view:

| remote view |--ODBC-->| view -> base table |
|---Client-----| |---VFP 6 server-----|

client is VFP3, server VFP6.

the remote view is created using SQLEXEC to get a query, then using CURSORSETPROP() to make it updatable.

when a change is made to the remote view in the client, a tableupdate() is executed, and the change propogates all the way through to the base table. the base table then has some default values filled in. (* see note below). the client then executes a refresh() to get the new data from the vfp6 server (including the new default values).

this refresh always returns 0.

any ideas on why this could be happening?

the vfp docs say refresh() doesn't work with buffering on, but you can't switch buffering off for a view... ("views require either DB_BUFOPTROW or DB_BUFOPTTABLE")

NOTE: this doesn't happen with an Oracle server with roughly the same table structure...

* actually, to get both the view and base table to be in sync in the vfp6 server, a stored procedure is called which calls TableUpdate() and requery for the view... (very kludgy, but the views only update one level deep...)


thanks in advance,
Tom

(ps given email not working right now... please post to universal thread... or madmick@yoyo.cc.monash.edu.au)