Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Joining a Fox Cursor with a SQL-Server SQL Passthru
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Joining a Fox Cursor with a SQL-Server SQL Passthru
Miscellaneous
Thread ID:
00458614
Message ID:
00458614
Views:
56
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?
Next
Reply
Map
View

Click here to load this message in the networking platform