select columns by position not name

[mcnews]

select 0, 2, 4 from mytable

query syntax?

tia,
mcnewsxp

 

[mcnews]

select 0, 2, 4 from mytable

query syntax?

tia,
mcnewsxp

i assume there's no way to do this.
i ended up looping thru fields and storing names.

 

[Gene Wirchenko]

select 0, 2, 4 from mytable

query syntax?

There is none. Even if there were, it would be silly to use it
since a change in the table structure could break a lot of code.

Sincerely,

Gene Wirchenko