>Hi Ulises,
>
>How big are your fields? The maximum key length is 240.
>
>>Hi all...
>>I have a table which sometimes I need it to be sorted using two fields. In the table design I set a regular index like:
>>Name: MyIndx, type Regular, expression field1+field2
>>
>>The command SET ORDER TO fieldx works fine but if I issue the command "SET ORDER TO myIndx" it sorts only by one of the fields.
>>What am I missing?
>>
>>Thanks in advance
>>
>>Ulises
As long as the collate sequence is MACHINE its 240. Otherwise, I think it's 120 because of double byte characters.