Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Sharing Connection
Message
 
 
À
24/02/2012 10:43:29
Moacyr Zalcman
Independent Consultant
São Paulo, Brésil
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Desktop
Divers
Thread ID:
01536435
Message ID:
01536440
Vues:
44
What you're looking at are Statement handles and they always will be different.
Try
? SQLGETPROP(CURSORGETPROP("ConnectHandle","editaisx1"), 'Shared")
...
>
>I´m trying to include two views in a transaction, but the connection handles are different.
>
>OPEN DATABASE E:\Solution93_DIS\DATA\atsbd.dbc SHARED
>CREATE SQL VIEW editaisx1 CONNECTION Conn SHARE as select * from editais
>USE editaisx1 IN 0 SHARED
>CREATE SQL VIEW editaisrx1 CONNECTION Conn SHARE as select * from editaisr
>USE editaisrx1 IN 0 SHARED
>?CURSORGETPROP("ConnectHandle","editaisx1")
>?CURSORGETPROP("ConnectHandle","editaisrx1")
>
>
>I get 1 and 2 for the connection handle of editaisx1 and editaisrx1 respectively. I'm using the keyword SHARE. I expected to have the same connection handle. What I'm doing wrong? How to effectively share the connection?
>
>Best Regards
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform