I send the results of remote server query execution to a table.
Then I do SQLEXEC and deliver records from that table to the front-end. The problem is that I have to SQLDISCONNECT first in order to execute remote query again and overwrite the result table. SQCEXEC keeps this table from overwriting or renaming. Any idea?
Thanks Mark