If the table wasn't in any index order, i.e. in recno() "order", and no order was imposed on the cursor. wouldn't the cursor therefore itself be in recno() order?
>Does anyone know the correct syntax to create a SQL VIEW and order it in record # order ? I tried to add "order by recno()" to the end of my create sql view definition but it returned an error SQL: Column ' ' is not found.
>
>Thanks For Your Help !
>
>Stephen J. Hunt
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.