Hi Everybody

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