Subject Re: GTT + VFP + Remote Views but VFP SQL Pass-Through does not show records
Author Bhavbhuti Nathwani
Hi Helen

Thanks for responding. Yes I had read the release notes and that is where I had started on this venture.

I did a few test and I think the connection that is used by the remote view and the SQL-PT are somehow different.

That said, I have confirmed that I can use multiple SQL-PTs in VFP and still get to see the data, so now I can populate the GTT using INSERT SQL-PTs and then later query the GTT again using SQL-PT and all is well.

Now comes the step where I need to ask a more dumber questions than before. First some background. I also use Report Manager as the reporting engine. This data I have populated to the GTT is now supposed to be used by Report Manager.

Now the yet dumber question. The Remote View in VFP uses one particular ODBC connection. This same ODBC connection is used when reporting in Report Manager, yet when the RV is shown as populated in VFP, the same ODBC connection used in Report Manager does not reflect the records in the RV.

Sorry for being such a bother but please advise.

Kind regards.