[sqr-users] Order by

["radhika reddy" <radhika_05@hotmail.com>]

Hi,

     I am having a problem using order by for a string variable ($type) in 
the following program(sample).

begin-procedure sample
begin-select
empname &ename
addr1 &addr1
addr2
sal  &sal
      let $sal=&sal
      if $sal>30,000
         let $type = 'SA'
     else
        let $type = 'SE'
     end-if
from table1

order by $type,empname,addr1    ! when i am giving $type in order by, it's 
not giving error but it's not giving desired output also

end-select
end-procedure

Any suggestions?

Thanks

_________________________________________________________________
Don’t just search. Find. Check out the new MSN Search! 
http://search.msn.click-url.com/go/onm00200636ave/direct/01/


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users