>
SELECT * FROM mytable ;
> WHERE state = m.myState ;
> ORDER BY sequence, eff_date DESC ;
> INTO CURSOR myCursor
>
>At first I tried doing it by creating an index expression which would allow me to
>
>
SEEK m.myState
>SCAN WHILE mytable.state = m.myState
>etc.
>
index ... on state + str(sequence) + str({^9999-01-01} - eff_date)
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)