General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2003 Server
Fair point!!
>John, wouldn't that just give an exact copy of the table, but with an extra field, "REC"?
>
>>How about this.
>>
>>sele *,recno() as rec from table order by rec
>>
>>>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only