select columns by position not name


Ad

Advertisements

M

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.
 
Ad

Advertisements

G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top