I doubt that ATC() is the problem. But you may try to prefix the field name with the table alias:
SET FILTER TO ATC(lcText, mytable.comments)
and if this doesn't work, try:
SET FILTER TO lcText $ upper(mytable.comments)
Vlad
>I have a form that I'm trying to use a filter with. I have button that the user can push that lets them enter a filter string. And then it uses the Command SET FILTER TO ATC(lcText, comments) > 0.
>
>Where lcText is the text that they are filtering on and comments is the name of the memo field.
>
>Basically I want them to only see records that have the text in the comments field. The problem is that I keep getting a GPF when I try switching from record to record with the filter set?
>
>Does anyone have any suggestions?
>
>Thanks,
>Don Knoup
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only