The data in a global temporary table is only available to the connection
that filled the GTT, so if you try to access it using a different
connection, it will be empty.

I am not sure how SQL Pass-through works in Visual FoxPro, but I think
it is highly likely that creates a new connection, and therefor the GTT
will be empty.


Bhavbhuti Nathwani wrote:

> Hi all
>
> I have create a GTT alright with ON COMMIT PRESERVE ROWS. I have a Remote View in Visual FoxPro which is populated with the temp data and I have confirmed that the rows are there in the RV.
>
> Next if I run a SQL Pass-through from VFP to the GTT I do not get any rows returned (nor can I view them from FlameRobin).
>
> I am using GTT to create store a list of accounts / items selected by the user and these records are then used to JOIN with other tables to bring out only the relevant rows.
>
> What am I missing.
>
> Please advise.

--
Mark Rotteveel