VFP9sp2: Capture SQL-Select statement

[Kurtwood]

Hi All,

Is there a simple way, like a COMMAND, to capture the SQL-Select statement that was last executed? I would like to save the statement to a memo field. I would also prefer not to save it to a .dbc or class in order to do this.

Most appreciated.

Kurtwood L Greene
The Bahamas

http://www.alvilda.com

 

[Olaf Doschke]

There is SYS(3092 [,cFileName [, lAdditive]]) to do that. Set the level of information with SYS(3054), as you want to see the sql commands executed set SYS(3054,2) or SYS(3054,12)

Bye, Olaf.

 

[Kurtwood]

Thank you Olaf,

It is what I am looking for and more.