>Fred,
>>>>
>>>>SET ALTERNATE TO file.ext
>>>>SET ALTERNATE ON
>>>>SYS(3054,11)
>>>>SELECT ....
>>>>SET ALTERNATE OFF
>>>>SET ALTERNATE TO
>>>>
>>>>You will now have your info as a text file.
>>>
>>> Before I (to be precise, my colleague), try this, I want to ask, does the information appear on the screen also or only in the file? We want to see this information during SQL execution, but also want to place this info, time elapsed, etc. into DBF, which we can use for statistics purposes.
>>>
>>> Thanks in advance.
>>
>>It shows on the screen, also. It shows in whatever is the currently active form, so you could bring up a form to show it in before you do the SQL.
>
> Right now it goes onto the screen. The problem is that the form overlappes it, I mean, the information is besides the form, so it's hard to see. I was thinking about temproraly hiding the form, and after SQL produced it's result, show it again. Could you advise better approach?

oSQLPlanForm = CREATEOBJECT('form')
WITH oSQLPlanForm
  .AutoCenter = .t.
  .Width = 400    && use whatever sizes you want
  .Height = 100
  .Show()
ENDWITH
SELECT ...

>
>>I didn't mention that once you had your text file, you could APPEND MEMO memofield FROM file.txt to get the info into a table.
>
> Yes, this part I can guess by myself :) Thanks.

I figured you would, but I should have put it in the first time, in case others were lurking.