Most of my views are opened with
USE SomeView CONNSTRING nSql IN 0 NODATA
USE ProblemView CONNSTRING nSql IN 0
The one that produced the headache was the last view that was opened in a similar fashion but without the NODATA clause.
The form is initially "empty" and when the user enters data in a field a number of Requery() statements are executed, but for one reason or another ProblemView
never reported that it was done fetching.
BR
Peter
>Yes, the connection busy makes no sense at all, especially if we have the asynchronious = .F.
>
>The funny thing is that I have another project in my laptop also using the SQL Server on my laptop, same framework, similar screens, similar data, but I don't get the connection busy problem.
Peter Pirker
Whosoever shall not fall by the sword or by famine, shall fall by pestilence, so why bother shaving?
(Woody Allen)