Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Dynamically change order of fields

3 views
Skip to first unread message

AntonE

unread,
Apr 6, 2007, 5:30:43 PM4/6/07
to
Is there a way to change the order (in the IB metadata) for fields in a
table?
Similar to IBConsole where you can alter a table & 'push' fields up or down?

Thanks


Bill Todd

unread,
Apr 6, 2007, 9:24:13 PM4/6/07
to
AntonE wrote:

With recent versions of IB you can change the column order using the
ALTER TABLE statement. I do not recall if this is possible with IB 6 or
not. The real question is why bother? You can specify any column order
you want in your SELECT statement.

--
Bill Todd (TeamB)

AntonE

unread,
Apr 7, 2007, 6:53:59 AM4/7/07
to
Ok thanks. Just an easy way to group fields in a table with many fields. If
I dynamically add fields at the end, it just becomes messy after a while.
"Bill Todd" <n...@no.com> wrote in message
news:4616e4ad$1...@newsgroups.borland.com...
0 new messages