You need to apply an ORDER BY clause to get the order you want from SQL, if you have a PK field, this USUALLY represents entry order.
Bob
>the command
>
>sele gtype distinct from vwxltbl into cursor vwxltblD
>
>sorts the field gtype, i wanted it to retain the original order, is that possible?
'If the people lead, the leaders will follow'
'War does not determine who is RIGHT, just who is LEFT'