Subject Re: [firebird-support] GTT + VFP + Remote Views but VFP SQL Pass-Through does not show records
Author Mark Rotteveel
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