Creating Indexes

[Ruslan Zasukhin]

On 3/10/07 10:02 PM, "Bart Pietercil" <bart.pietercil at gmail.com> wrote:

>>> So I would like to be able to set the name of an index through code.
>>> Possible ?
>> 
>> Right now no.
>> 
>> Okay, so we have 2 issues here:
>>     * assign names of indexes.
>>     * show names of indexes in Vstudio in some way.
>> 
> 
> Absolutely, this will help to get more meaningful errormessages.
> I think that it should be possible to have all features of an index
> addressable by the index name.
> I think we need two ways to address an index

> 1) renameIndex(indexedfieldname,newname)

Ok, missing.

> 2)rebuildIndex(indexname)

You can rebuild indexes now using

    VField.Reindex()
    VTable.Reindex()
    Vdatabase.Reindex()

Or their SQL analogs.


> 3)dropIndex(indexname)
    
    Vfield.indexed = false
 
> I also think that I should be possible to maintain more then one
> index (with different collation settings) on 1 field

Right now this is possible with help of Table Methods.
Please read docs.

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]