>Is there a way to select records from a SQL Server table based upon values in a VFP cursor using SPT? In concept its simply....
>
>SELECT * from SQLTable Where PK IN (Select PK from VFPCursor)
>
>but since SQL doesn't know the contents of the VFP cursor, it's obvious why this won't work. Is some other way -- other than Scan the cursor and retrieve them one at a time...


1. Try T-SQL table variables rather than temp tables if permissions is an issue.

2. Use ADO to connect to SQL and VFP heterogenous data.

Jay