thank you Sergey, I haven't test the collating sequence :-(
>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'
>>
>>