Alter Table Add field

[Tim James]

I appreciate your comments about standards etc, but I think you may be 
mistaken, both in Valentina app and alter table statement it appears to 
insert column at the front of all existing columns (1.9.8)
(I find * is easier than 35 column names!!)
TIA
On 09/12/2003, at 10:21 PM, Ruslan Zasukhin wrote:

> on 12/9/03 1:14 PM, Tim James at tjames1 at bigpond.net.au wrote:
>
>> I know this has been mentioned some time ago, but has there been any
>> change to
>>
>> so that alter table add field adds the field
>> at the END of the schema description so that any
>> original select * statements don't have to be respecified
>
> Hi Tim,
>
> It adds column to the end.
> And I think this will be always.
>
> This is VERY NOT correct expect some order of fields in the SELECT * 
> !!!
>
> This is written in all books and is true for each DBMS.
>
> Never expect this.
>
> IF you need some order, you MUST specify
>
>         SEELCT f1, f2, ...
>
>
> -- 
> Best regards,
> Ruslan Zasukhin      [ I feel the need...the need for speed ]
> -------------------------------------------------------------
> e-mail: ruslan at paradigmasoft.com
> web: http://www.paradigmasoft.com
>
> To subscribe to the Valentina mail list go to:
> http://lists.macserve.net/mailman/listinfo/valentina
> -------------------------------------------------------------
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>