We have an existing set of applications written in FP2.6 & VFP3.0. All are being converted to VFP 6.0 using the VMP 4.0 framework. As a phased approach, we are converting everything to ODBC (still using FP2.6 tables) and then moving that dataset to SQL Server 7.0. Our code is written bydirectionally so that when we are ready, we can move the data over to SQL Server and just flip a switch in a table and the code will work. Our database includes over 200 tables and approximately 6 Gig of data.

The issue: On NOT ALL but several instantces, we have tableupdate()s that return .T. -- but if we need to immediately requery the updated table (for view purposes, or further data manipulation) the updated do not show up. Also, if we put a wait loop in (for 5 - 15 seconds) and then to the query, the data shows up.

So the code might look like this:

*---- Begin Code ---------------*
*/ add customer to view
SELECT customer_view
REPLACE customer_view.address with lcMyAddressVariable
IF TableUpdate(.T.,.F.)

Thisform.RequeryCustomersView( customer_view.custkey )
Thisform.RefreshGrid()
ENDIF
*----- End Code ----------------*

This may not show the new address.


Any Ideas?

Randy
RRosenth@utilicorp.com