Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQLEXEC and Shared Connection Problems
Message
From
11/11/2004 14:10:44
 
 
To
11/11/2004 13:57:51
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8
OS:
Windows XP SP1
Database:
MS SQL Server
Miscellaneous
Thread ID:
00960314
Message ID:
00960577
Views:
9
>Hi Bernard,
>
>The "ConnectBusy" property checks the status for the SPT connection handle you are passing to SQLGETPROP. In the example, lnhandle is not busy, but the CURSORGETPROP("ConnectHandle","MyRemoteView") is. Note, in most scenarios, if AllowSimultaneousFetch=.T. for the busy connection handle, you should still be able to execute command through another SPT connection handle that uses the same ODBC connection. In your example, you should still be able to execute something through lnhandle even though the MyRemoteView is still fetching.
>
>Thanks,
>Aleksey.

Then Connectbusy it is StatementBusy.

Sorry Aleksey,
but i try to use AllowSimultaneousFetch and VFP8SP1 it begins to fry.

You can post a simple ( two cursors ) code ( from pubs/NorthWind ) where
AllowSimultaneousFetch do it makes its it must ?

Thanks.
Fabio
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform