Subject GTT + VFP + Remote Views but VFP SQL Pass-Through does not show records
Author Bhavbhuti Nathwani
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.

Thanks and regards.