Hi, all
I create a simple database with:
CREATE CONNECTION Teste DATASOURCE TesteConn
CREATE SQL VIEW "Vcategoria" ;
REMOTE CONNECTION "Teste" SHARE;
AS SELECT * from categprod
DBSetProp('VCategoria', 'View', 'ShareConnection', .T.)
CREATE SQL VIEW "Vbanco" ;
REMOTE CONNECTION "Teste" SHARE;
AS SELECT * from banco
DBSetProp('VBanco', 'View', 'ShareConnection', .T.)
After I run this:
CLOSE DATABASES all
OPEN DATABASE teste
USE vbanco IN 0
USE vcategoria IN 0
linhandles=ASQLHANDLES(aConnection)
DISPLAY MEMORY LIKE aConnection
and I get two distinct connection handles for the views. The views are suposed to share the connection
I'm doing something wrong?
TIA