Ding! The light just cam on. I know what is going on here. The first query you do opens the view in the ODBC connection. You then close the return cursor, but the view is still open in the connection. You update the source table and the change does get committed. You then issue another SQL to retrieve the data from the view. Since the view is still open in th connection, you get the original value returned because the SQL does not know to issue a REQUERY('TestView') before returning the results from the view.
When you close the connection, the view and the table gets closed. So when you open a new connection, the view is not yet open, so when you query it again, you get the correct results. Unlike Oracle or SQL Server, VFP views are not dynamic. There data remains static until a REQUERY() is issued.
Mark McCasland
Midlothian, TX USA