Vserver V4MD AddField

[Ruslan Zasukhin]

on 11/16/03 10:50 PM, Florian Bogeschdorfer at fb at memedia.de wrote:

Hi Florian,

> I have made my Db ready and a 4000 records inside. Now I have added 3 more
> fields in one base object afterwards.
> 
> AddField(VAL[#ID], VAL[#PLUtable], "PLU_AutoIn", #kTypeBoolean)
> 
> I have some questions:
> 
> 1. All three fields are indexed automatically. Why? (I see it in the XML
> dump)

May be you have made search on this fields after add?
Then Valentina add index.

> 2. When will these changes (adding fields) become permanent or are safe?
> After flushing or after closing or after valentinashutdown() ?

Shutdown is not needed of course.

Usually flush is enough.

But methods that change db structure do flush self immediately.

> 3. Those fields in records that have already existed will have which value?
> Emnpty for string, NULL for numeric?

Empty for String
ZERO for numeric,

And if you have made field Nullable then for String and for numeric
It will be NULL.

-- 
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
-------------------------------------------------------------