Subject Re: [ib-support] Field Order
Author Helen Borrie
At 10:24 AM 08-05-02 +0000, you wrote:
>When doing a Select * from .... is it guaranteed that the fields will
>appear in the creation order ?

They should appear in *position* order - which might or might not be
"creation order", since it is possible to alter the degree (column order)
of any table using ALTER TABLE ALTER COLUMN aColumn POSITION n

>if not how can I guarantee that ?

Specify your output set's degree by providing a column list to your SELECT
clause. SELECT * is not recommended practice for serious work.


All for Open and Open for All
Firebird Open SQL Database · ·