Subject Re: applylocate not working
From Heinz Kesting <>
Date Sat, 8 Jun 2024 15:01:40 +0200
Newsgroups dbase.getting-started

Hi Charlie,

> I thought this would be easy since I have done this before but the apply locate is never found.  tgrade is what i am trying to find.  actually it represents a field in the table.  so that isn't the problem (yet) because this never finds tid and cat which are also strings.
> i have tried this looking for bith variables and only one which certainly should have been found, but for some reason the applylocate doesn't work.
Well, I know I'm a bit late for the party, but what helped me
understanding ApplyLocate() was first
- using square brackets for building the string to make it easier to
read, and second
- displaying the string that you finally submit to ApplyLocate()

so something like:
cSearchString = [>] + [year = '] + tid + [' and category = '] + tcat +
[']) + [<]
? cSearchString

Now between the pointed brackets you can easily see what you actually
make ApplyLocate() look for.

Finally, please remember to check for apostrophes in the field values.
If this could be the case, make sure you're preceding the apostrophe
with a backslash. For this see the help for the rowset's filter where
this is explained in greater detail.

The rowset's locateOptions have already been discussed, so you should be
Okay now.

Just my two cents, hope they help, too

Kind regards, Heinz