>>>>I'm pretty sure of the respond but, is there a way to make (like) a join
>>>>between a remote and a local table using SQLExec. The way I did is I do a
>>>>scan from the local table and I go retrieve the info. I want from the remote
>>>>table. I hope there is a better solution. Thanks!
>>>
>>>SQLExec will retrieve a cursor, and this cursor can be joined to local table. I am not sure, it's what you are asking...
>>
>>I will be more specific, sorry!
>>I have a local cursor wich have all the primary keys I want to access in the server. I want
>>to retreive specific information on the server using the primary key. But I can join
>>a Local cursor to a remote table. So, I loop through the local cursor and use SQLExec
>>to retreive one row at a time. Is there another "better" way to do this?
>
>I think you are doing normal way, assuming that you have reasonably high number of randomly assorted keys.

The reason I do this way is because I can't do it all in SQL Server. I have specific
functions in Visual FoxPro. At this time, it wasn't a problem because the number of
records wasn't too much. But, if the local cursor is 20000 records. I will loop 20000
times! Maybe, il will transfer my functions in SQL Servers stored procedures. So I will
be able to do it all in one select.

Thanks