Tony Caduto schrieb:
> I think a client that tells me the columns are a, b, c but then
>
>> gives me an error on "insert into table values (aval, bval, cval)"
>> because
>> the actual logical order is different is probably fairly broken.
>
>
> I guess that could be a problem, I was thinking in terms of how I do a
> insert, I rarely do it that way, I usually specify the columns by name i.e.
> insert into blabla (fieldname1,fieldname2) values('bla','bla')
>
> oh well, there goes that idea :-)
Maybe you can save it if you "mis"-use the column comments and
make your gui-client oder on: attnum or column-name or comment.
And if you have a table where you still cannot find the column
you want, there is a strong evidence for redesign I'd say ;)
Regards
Tino