Clarion - Re: Case sensitive not working?

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: Case sensitive not working?

Davor Mariæ

2004-04-07, 10:30 am

Thanks Bob,

I've changed my .Fetch to
SET(...
..Next OR LOWER(findstring) <> LOWER(tablestring)...,
works fine.

Regards,
Davor

> In short, for a TopSpeed file, with the key as case insensitive (meaning
the
> key stores Smith and SMITH in the same way--it is "insensitive" to know
the
> difference), a fetch is case sensitive.
>
> Case sensitivity in the key only means that the data is sorted with upper
> case preceding lower case (in their positions of the ASCII table). SMITH
> comes before Smith (SMITH is stored as SMITH in the key; Smith is stored
as[color=darkred]
> Smith in the key).
>
> Bob.
>
> matched.
is[color=darkred]

Sponsored Links