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.

Helen


All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org ·
http://users.tpg.com.au/helebor/
_______________________________________________________