>I have a cursor that ORDERS the data during creation of that cursor. Is there a way to RESORT the cursor without having to reselect the data?
I can imagine two ways.
1)
Create the original cursor with NOFILTER.
SELECT * FROM QUERY1 ORDER BY MYFIELD INTO CURSOR QUERY2
2)
INDEX on MyField to Temp
For working safely over a network, create index names with sys(2015).
HTH, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)