>
>Thanks for your replies, and I've already looked in Cursor and DB getprop and neither have an "order" prop that I can query...oh well, I'll keep fiddeling:)

Hey! It just occurred to me that you could select the order by field as one of the fields.

Something like, select *, "partno" as orderby from mytable order by partno.

Would that help?