Sinppage
>
>Just my .02 (US) here. I'd opt for names. I think it's more flexible. Using the field number ties query to the order of the field within the table. If the structure changes, say a new field is inserted, then this would have to change too. Using the name doesn't have this problem.
George,
While I always prefer names too, I have had many cases where the field number was the only way to get an ORDER BY to work!
Cheers,
Jim N
Previous
Next
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