Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Cursor INNER JOIN with client server table
Message
 
À
03/08/2005 12:18:11
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
01038183
Message ID:
01038231
Vues:
21
Michel,

You can pull down all the possibly related SQL data into another VFP cursor, then do the JOIN on the two cursors. Or you can push your cursor into a SQL table and then do the JOIN in SQL and return the results. Or you can put the cursor into a VFP table and then have a SQL SP do the JOIN using OPENROWSET to access the VFP data directly over ODBC. There may even be a few more ways to do it, but the way I'd recommend (without know how much data is involved -- which could alter the option chosen) is the first one. Pull down the SQL data and JOIN the two cursors in VFP. The other options are less reliable or more klunky IMO.

HTH,
Chad

>I have created a cursor. That cursor should be in a SQL where the INNER JOIN with a table from the backend. How can I succeed to execute a SQLExec() where one of those tables is a cursor?
_________________________________
There are 2 types of people in the world:
    Those who need closure
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform