>>>>Invalid key length
>>>>
>>>>line of code giving this problem is:
>>>>
>>>>INDEX ON LOWER(cClass + cMember + PADR(mName, 128)) TAG PrimaryKey
>>>
>>>You have very long name of the method (the key could only be 240 chars).
>>
>>And if the collating sequence is anything but Machine, half that.
>
>Yes, so it would not work at all with PADR(..,128).
>
>BTW, in the above reply I meant cClass and cMember - their length together may be more than 112 characters.
Thanks Naomi.
*******************************************************
Save a tree, eat a beaver.
Denis Chassé