Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
What to do when a shared connection gets busy?
Message
De
28/04/2005 03:28:52
 
 
À
28/04/2005 03:20:53
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01009096
Message ID:
01009118
Vues:
17
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)
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform