Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sharing Connection with Remote Views
Message
From
02/03/2007 16:05:34
Moacyr Zalcman
Independent Consultant
São Paulo, Brazil
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Sharing Connection with Remote Views
Miscellaneous
Thread ID:
01200415
Message ID:
01200415
Views:
65
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
Next
Reply
Map
View

Click here to load this message in the networking platform