Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQLEXEC and Shared Connection Problems
Message
De
11/11/2004 14:10:44
 
 
À
11/11/2004 13:57:51
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 8
OS:
Windows XP SP1
Database:
MS SQL Server
Divers
Thread ID:
00960314
Message ID:
00960577
Vues:
8
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform