Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What to do when a shared connection gets busy?
Message
From
28/04/2005 03:28:52
 
 
To
28/04/2005 03:20:53
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01009096
Message ID:
01009118
Views:
16
These settings solved the problem (forced REQUERY or SQLEXEC to be synchronous so the connection can't ever be busy)

for SQLEXEC at startup of app (before SQLCONNECT is called):
SQLSETPROP(0,'Asynchronous',.F.)

for views that all share one connection (need to be set for every view):
DBSETPROP('viewname','VIEW','AllowSimultaneousFetch',.F.)
DBSETPROP('viewname','VIEW','FetchAsNeeded',.F.)
DBSETPROP('viewname','VIEW','FetchSize',-1)
DBSETPROP('viewname','VIEW','MaxRecords',-1)

Now you can do away with your loop and wait.

>Hi Peter,
>
>I don't have access to the Search Feature of Universal Thread. Can you post the message?
>
>Thanks in advance....
Peter Pirker


Whosoever shall not fall by the sword or by famine, shall fall by pestilence, so why bother shaving?

(Woody Allen)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform