Memo searches

[youwannawhat]

We have a memo field that's written to as part of a transaction log. How can I search through the memo fields in the table for a specific string?

 

[IRABYY]

You can use either AT() or ATC() functions against Memo field. I did it, it worked.

 

[Mike Gagnon]

You may try:

myValue $ myMemo

 

[youwannawhat]

How would you use ATC() to find a string 'JONESMR'?

 

[chpicker]

AT() and ATC() are good if you know which record it's in and want to know WHERE in that memo file it is. If you want to find a record that contains a string, you need to use the $ operator like this:
[tt]
LOCATE FOR cSearchString $ MemoField
[/tt]
It's slow, but without some kind of keyword list there's no real way to optimize the search.

Ian