Information générale
Titre:
Joining a Fox Cursor with a SQL-Server SQL Passthru
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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement