Alter Table Add field

[Tim James]

Thanks - I have made my code conform to standards - Is there a large 
overhead in parsing column names?
On 09/12/2003, at 11:53 PM, Ruslan Zasukhin wrote:

> on 12/9/03 1:53 PM, Tim James at tjames1 at bigpond.net.au wrote:
>
>> 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)
>
> Aha, I see what you mean. IF there was deleted column then yes,
> New will be inserted
>
>> (I find * is easier than 35 column names!!)
>
> Yes, easier. But it is wrong and can cause problems.
>
>> 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
>