Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sharing Connection
Message
 
 
To
24/02/2012 10:43:29
Moacyr Zalcman
Independent Consultant
São Paulo, Brazil
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01536435
Message ID:
01536440
Views:
45
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--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform