Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
We can always hope...
Message
From
20/10/1997 15:31:02
Sonny Chouinard
CHCA Computer Systems Inc.
Lachenaie, Quebec, Canada
 
 
To
20/10/1997 15:25:57
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00055592
Message ID:
00055597
Views:
23
>>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?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform