If the collating sequence is not set to MACHINE then index key length is limited to 120 characters.
>I got into this problem :
>I want to create a table programmatically and also create an index,
>I got the error invalid key lenght but if I create the index via builder
>it's ok. How come ? I try to create the table as free and also belonging to a dbc but without success.
>I tried with the command create table
>I tried with create table and then alter table
>i tried with create table followed by the command index on
>
>nothing to do.
>
>here is my source
>
>
>Create Table (xpath + 'Myform') free (nomeform c(20),controllo c(200),
default c(60), field1 c(60), field2 c(60), field3 c(60), field4 c(60), field5 c(60))
>
>index on nomeform + controllo tag 'chiave'
>
>
--sb--