AW: Vserver V4MD AddField

[Florian Bogeschdorfer]

> -----Ursprüngliche Nachricht-----
> Von: valentina-bounces at lists.macserve.net 
> [mailto:valentina-bounces at lists.macserve.net] Im Auftrag von 
> Ruslan Zasukhin
> Gesendet: Sonntag, 16. November 2003 22:08
> An: valentina at lists.macserve.net
> Betreff: Re: Vserver V4MD AddField
> 
> 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.

No, I added the fields and made a flush. That's it.
> 
> > 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.

Mmmh. I added the fields, then I made an XML dump and the fields were not in
it. Then I flushed and closed, reopened and then they were there...
> 
> > 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
> -------------------------------------------------------------
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina