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
Précédent
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