Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Connection Busy Problem
Message
From
14/04/2005 03:37:33
 
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01003548
Message ID:
01004500
Views:
25
Most of my views are opened with
* Form Load
USE SomeView CONNSTRING nSql IN 0 NODATA
* open a bunch of other views with 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)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform