Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
GPF with SET FILTER adn ATC()
Message
From
13/10/1998 19:48:03
 
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00146261
Message ID:
00146443
Views:
25
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
Map
View

Click here to load this message in the networking platform