If using views and your connection is in the database where your views are defined, Modify database, right click, select connections, modify your connection. In the connection designer, under data processing you should see asynchronous execution. Uncheck it and try your updates without the wait state. You can also check the state with

dbgetprop( cConnectname , "connection", "asynchronous" ) 
*!* set it with 
dbsetprop(cConnectname,"connection","asynchronous",.f.)

For SPT, checkout SQLGETPROP() and SQLSETPROP() and Asynchronous batch processing mode in VFP help.


>Where do I set the connection type? I did not see it when I setup the DSN and I do not see it in the remote view.
>
>Thanks
>Joel