>>>Hi,
>>>
>>>I have the following problem. How can I give a variable value for the order by clause of the select
>>>statement
>>> eg: Select * from aaa into cursor ab order by (mvar)
>>>
>>>so that I can change the value of mvar as required.
>>>
>>>2. Sometime back I saw in this forum to use REPORT FOR myreport NO CONSOLE to get the
>>>page no. But how can I store the page no. in a variable to be used in the actual printing of the
>>>report. I mean without releasing the last page no.
>>>
>>>thanks
>>>
>>>alex
>>
>>
>>1. SELECT blah FROM blahblah ORDER BY &Var.
>>
>>2. Look at the _PAGENO system variable.
>
>Hi,
>
>Thanks for the reply. But it didn't work for me. I have defined a property myVar. Then I used
>SELECt blah blah ORDER BY &thisform.myvar. It didn.t work.
>
>_pageno system variable gets released immediately after the REPORT command is commpleted. How can I
>save it for the next actual print
>
>TIA.
>
>alex


No, it is a system variable. It is always available.