What is it you are trying to do? Update remote data with current values in your local data? If so, what you are doing is fine because this is what a remote view would do if ou updated its data then issued a TableUpdate().
If not, are you trying to retrieve data from the remote server based on a set of local IDs? If so, you can build a temporary cursor on the remote server that just contains those IDs, then execute a stored proc to return a cursor from the remote table of records that match those IDs.
>Hello,
>
>I am trying to match local data to remote data using SQL passthrough (SQLEXEC) in Foxpro. I am trying to match the local data to the remote data on an ID field. The remote data is too large to download and the local data cannot be uploaded to the remote server through my program (to the best of my knowledge). So, my program currently writes the ID value to the SQL string then passes the SQL to the remote server for EVERY unique value of the ID I have in the local data. Therefore, if my local data has 100 unique ID values, I write an SQL statement and pass it to the remote server for processing 100 times. Is there a more efficient way to do this? Can the whole local dataset be processed at once somehow? Please be patient with me on this as I am a very novice programmer.
>
>Thank you,
>Justin
Mark McCasland
Midlothian, TX USA