Hi,
May be you should try this
INDEX ON ALLTRIM(mill)+ALLTRIM(bank)+ALLTRIM(branch) TAG myIndexName OF table21.cdx
It will create compound index (.cdx) file
For a standalone index (.idx) file, the length of an index key must be between 1 and 100 characters. For a compound index (.cdx) file, the length of an index key must be between 1 and 240 characters.
HTH
I am not the most powerful man in this world.
I am not the worst man in this world either.
I just as same as all of you.
I still need to learn from my mistakes...