Hi,
You need to be sure that the result of the index key is always the same lenght.
INDEX ON SUBSTR(FIELDGET(ff),1,256) TO Inp_tmp UNIQUE
If the result if fieldget(ff) is less than 256, the indexkey won't be 256 characters!
INDEX ON PADR(FIELDGET(ff),256," ") TO Inp_tmp UNIQUE
With PADR it will always be the same lenght.
Secondly, I don't know if an indexkey can be 256 characters in lenght. I don't think it can.
Is there a portable ADS with an ISAM interface?
- Eugene Lutsenko
- Posts: 1649
- Joined: Sat Feb 04, 2012 2:23 am
- Location: Russia, Southern federal district, city of Krasnodar
- Contact:
Re: Is there a portable ADS with an ISAM interface?
Thank you very much, Skiman! Now everything has worked out. I will keep this requirement in mind