Great, you just made my day.

BR

Peter

>Hello,
>
>i've had the same problem once with remote views.
>
>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)
>
>Regards
>Christian