Is there a portable ADS with an ISAM interface?

This forum is for eXpress++ general support.
Message
Author
skiman
Posts: 1185
Joined: Thu Jan 28, 2010 1:22 am
Location: Sijsele, Belgium
Contact:

Re: Is there a portable ADS with an ISAM interface?

#41 Post by skiman »

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.
Best regards,

Chris.
www.aboservice.be

User avatar
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?

#42 Post by Eugene Lutsenko »

Thank you very much, Skiman! Now everything has worked out. I will keep this requirement in mind

Post Reply