How can I order a cursor

[chi1]

Please let me know how to order a cursor in the program. Thanks.

 

[EzLogic]

if you are reffering to sorting an order then

Sele field1,field2,... from MyCursor order by MyCursor into cursor MyCursor

Please let me know if this helped you

Tekno
Wireless Toyz
Ypsilanti, Michigan

 

[csr]

After creating it, Create a tag or index or ...

Order it while creating it with the SELECT command.
Don
dond@csrinc.com

 

[chi1]

This doesn't work.

Here is how I created a cursor:
sele qacode, descr from qacode into cursor qsel

Then I tried to order it by Descr, like following:
Sele * from qsel order by descr into cursor qsel

But I get an error message saying that a table has to be created.

Thanks for your help.

 

[DSummZZZ]

You can't use the same alias for both. Try:

sele qacode, descr from qacode ;
into cursor qsel order by descr

Dave S.