Article View: borland.public.interbase.opensource
Article #93Re: Dynamically change order of fields
From: AntonE
Date: Sat, 07 Apr 2007 10:53
Date: Sat, 07 Apr 2007 10:53
19 lines
1615 bytes
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)
Technical Details
Message-ID:
<4617785a@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mailReferences:
<4616bc14@newsgroups.borland.com> <4616e4ad$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 106772,67f3059fb80ce7b6 X-Google-Attributes: gid106772,public X-Google-Language: ENGLISH,ASCII-7-bit From: "AntonE" <antone@true.co.za> Newsgroups: borland.public.interbase.opensource References: <4616bc14@newsgroups.borland.com> <4616e4ad$1@newsgroups.borland.com> Subject: Re: Dynamically change order of fields Date: Sat, 7 Apr 2007 12:53:59 +0200 Lines: 21 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.3028 X-RFC2646: Format=Flowed; Original X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028 NNTP-Posting-Host: 196.34.167.131 Message-ID: <4617785a@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1175943258 196.34.167.131 (7 Apr 2007 03:54:18 -0800) Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail