Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Joining a Fox Cursor with a SQL-Server SQL Passthru
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
Joining a Fox Cursor with a SQL-Server SQL Passthru
Divers
Thread ID:
00458614
Message ID:
00458614
Vues:
57
If you have a cursor in Foxpro, can you do SQL Passthru that is joined to it? And if so, how? I cannot find it in help or any books.

Say the cursor name is cEMPLOYEES.
If everything was in Fox, my select statement might be:
SELECT INDIVIDUAL.NAME, cEMPLOYEES.EMPNO ;
FROM INDIVIDUAL INNER JOIN cEMPLOYEES ON INDIVIDUAL.INDNO == cEMPLOYEES.INDNO

However, if the INDIVIDUAL table was in SQL Server and I wanted to only pull the individuals who's IndNo exists in the cEmployee cursor using SQL Passthru, how would I do that?
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform