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)