Yes this should do. Anyway I don't like the candidates and primarys on fields exposed to the user. One deleted could do so much harm.
Is optometrist norsk? Neat.
Agnes
>Yes, it is, and I even wanted to write that. But I thought that I should try it first. Since I received an error message, I thought it was a syntax error, but it was a "Uniqueness of index xx is violated" message. I'm off to the optometrist now to get new glasses! :-)
>
>In other words the shortest syntax is
>index on upper(surname-firstnames) tag NAMEUNIQUE FOR internal=1 CANDIDATE
>
>>Hi Tore,
>>
>>surname-firstnames
>>
>>
>>should not need PADR. The spaces from surname are moved to the end of the string.
>>
>>Agnes
>>>>Hi
>>>>just wondering whats wrong with syntax below !!?
>>>>
>>>>index on trim(upper(surname))+trim(upper(firstnames)) tag NAMEUNIQUE FOR internal=1 CANDIDATE
>>>>
>>>>the error is ,Command contains unrecognized phrase/keyword (Error 36)
>>>>
>>>>if i remove keyword "candidate" it goes thru fine but i need to create unique index.
>>>>any ideas much appreciated
>>>
>>>The reason for this error is that the index expression does not always create index keys of fixed length, which is a requirement.
>>>index on padr(upper(trim(surname)+trim(firstnames)),50) tag NAMEUNIQUE FOR internal=1 CANDIDATE
>>>Or even shorter
>>>index on padr(upper(surname-firstnames),50) tag NAMEUNIQUE FOR internal=1 CANDIDATE
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]