>>>Hi Tamar, thanka again for your assistance.
>>>How exactly does Sys(3092) work.
>>> I have an exe with say 300 forms and 150 prg files. Lets say I switch on this option, then start the app and assume I go into every single form in the app (just go in and out) will I get just a listing of those SQL statements that are not optimised..
>>
>>Nope, you'll get the normal SYS(3054) output for every query (and view) that you execute, so just going in and out of each form probably won't do it.
>>
>>Try code like this:
>>
>>SYS(3092, "SQLLog.TXT")
>>SYS(3054, 12)
>>
>>* Run your app
>>
>>SYS(3054,0)
>>SYS(3092, "")
>>
>>Tamar
>
>How can you prevent output from echoing to the screen?
>
>Thanks.

set console off

PS: I think a better way is to use 3rd memvar parameter.

Cetin