SQL Pass Through

[risslsu]

How do I reference a remote table so that I can use a SELECT statement and put the results into a cursor? I have already established my connection with the server.(SQL Server)

This is my code using a local table:
SELECT TOP 1 * FROM table INTO CURSOR table_cur ;
WHERE ALLTRIM(table.field1) == m.field1 ;
ORDER BY table.field1

Should I use SQLEXEC, SQLPREPARE?

Thank you,
Marissa

 

[JohnDTampaBay]

This is not SQL Server code. Possibly Oracle or FoxPro. Please post to the correct forum. Happy coding.

--Angel
-----------------------------------
Every time I lose my mind, I wonder
if it's really worth finding.

 

[SQLBill]

This is also a duplicate post of THREAD183-762621.

-SQLBill