Dynamically change order of fields

Thread View: borland.public.interbase.opensource

3 messages

[T] Back to Threads [V] Tree View [G] Group Articles

3 total messages Started by AntonE Fri, 06 Apr 2007 21:30

#91

Author: AntonE
Date: Fri, 06 Apr 2007 21:30

5 lines
969 bytes

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

Re: Dynamically change order of fields

#92

Author: Bill Todd
Date: Sat, 07 Apr 2007 01:24

15 lines
1419 bytes

AntonE wrote:

> 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

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)

Re: Dynamically change order of fields

#93

Author: AntonE
Date: Sat, 07 Apr 2007 10:53

19 lines
1615 bytes

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" <no@no.com> wrote in message 
news:4616e4ad$1@newsgroups.borland.com...
> AntonE wrote:
>
>> 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
>
> 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)

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads