Query Spy

[L0stAngel]

I have a program that runs a report and gets data from a VFP database. I was wondering if anyone knows of any query spies for VFP that I could either run client side, or server side, that will get me the actual query being ran.

 

[Imaginecorp]

...that will get me the actual query being ran.

Do you mean the query syntax?

 

[white605]

Sounds to me like you need Spector Pro software

http://www.spectorsoft.com

 

[baltman]

Sounds like there is an application from which L0stAngel wants to scrape the view/reporting logic. I don't think Spector would help.

Perhaps the developer of the software would be of help? The software should be able to save the SQL to a log if you have access to the source code.

 

[beedubau]

Sometimes you can see the SQL if you look at the exe in a HEX/text viewer. Just a thought.

Bryan

 

[Olaf Doschke]

If the app uses VFP ODBC driver there might be a chance of turing logs on. If the app is VFP natively accessing the vfp data, you couldn't even do network packet sniffing, the sql engine runs clientside and you only could log which portions of which files are read, if you can filter the packets sufficiently.

Are those reports standalone FRX files? Then you can probably see inside, what tables are accessed, if the dataenvironment of the frx are used.

Bye, Olaf.