Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Sharing Connection with Remote Views
Message
De
02/03/2007 16:05:34
Moacyr Zalcman
Independent Consultant
São Paulo, Brésil
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
Sharing Connection with Remote Views
Divers
Thread ID:
01200415
Message ID:
01200415
Vues:
64
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform