Updating the Schema

[Ruslan Zasukhin]

On 6/25/04 12:28 AM, "Juergen Schreck" <lists at innernine.com> wrote:

> 1) I have to update the Schema of a database table in code. I have the
> basics down, e.g. I can add a method using
> 
>    fld=me.UserClips.CreateField("cliptext_eq", kV_TypeVarChar, 512,
> "ASCII", "cliptext")
> 
> BUT: How do I make this field indexed? There doesn't seem to be a
> version of CreateField that allows setting the flags in a 3rd
> parameter?

    Vfield.Indexed = true


> 2) My table has a field which is IndexedByWords. I want to remove that
> in my Schema Update. How can I do that?

    fld.IndexbyWords = false


> 3) Do I have to increment/change the Schemaversion by resetting the
> property manually or does ValentinaKernel update the schemaversion when
> I create fields dynamically?

If you have already users and they work with your db,
Then yes it is recommended.

If you are in state of development you do not need this.

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