General information
Title:
SQL Passthrough- Matching Local to remote data
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only