Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Insert into table from Memvar is too slow for Fox?
Message
From
14/10/2003 10:10:39
 
 
To
14/10/2003 08:55:53
Joel Hokanson
Services Integration Group
Bellaire, Texas, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00838321
Message ID:
00838521
Views:
24
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
Previous
Reply
Map
View

Click here to load this message in the networking platform