Mike Yearwood
Toronto, Ontario, Canada
Information générale
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Network:
Windows 2003 Server
Hi Mike,
Are you insinuating that I did not read the help file? :-) I did, under SET COLLATE but did not see anything. It actually dawned on me 1/2 an hour after posting this to try that (isn't that usually the case - as an old guy used to say "thoughts disentangle themselves when they flow over the lips or through the finger tips".
Regarding the UPPER() on the vars, I would have thought that this only fired once at the start of the command firing - not on every row. Just trying to avoid a couple extra lines.
As you can probably tell, this discussion was also picked up over on Foxite. I had hoped that Steve Black might jump in as he used to be at least the guru on accented characters etc. I used his INTL app years ago to INTLize a hockey app. Everything seemed to work there - maybe I had better go over and open up that 2.6 code...
Albert
>You will have to SET COLLATE TO GENERAL before doing the SELECT. Says so right in the help. :)
>
>While you're doing that you might also upper your memory variable once in advance of the query rather than per row.
>
>SET COLLATE TO GENERAL
>lcLastName = UPPER(m.lcLastName)
>lcFirstName = UPPER(m.lcFirstName)
>
>SELECT Lastname, Firstname ;
> FROM Lawyers ;
> WHERE UPPER(lastname) == m.lcLastname AND ;
> UPPER(Firstname) == m.lcFirstname ;
> INTO ARRAY laNames
>
>HTH
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement