Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
BROWSE command problem
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00592850
Message ID:
00592903
Views:
14
The filter expression is evaluated every time pointer is moved in the table not at the time when SET FILTER command is issued. You can create "static" filter condition.
 lcFilter = [fieldvalue = "] + Thisform.propertyname +["]
...
             SET FILTER TO &lcFilter 
>I'm trying to perform what should be a simple browse of a filtered database. My syntax is
>
>IF !EMPTY(Thisform.propertyname)
> SET FILTER TO fieldvalue = Thisform.propertyname
> GO TOP
>ELSE
> SET FILTER TO
> GO TOP
>ENDIF
>
>IF !mupdate
> BROWSE NOAPPEND NOEDIT NODELETE LAST
>ELSE
> BROWSE LAST
>ENDIF
>
>I get the message "Object is not contained in a FORM" before the browse window opens and my filter condition is ignored.
>
>When I suspend, the debugger shows that the error is occurring at the BROWSE command line.
>
>I'm using tables and not databases. If I comment out the SET FILTER commands and just issue the BROWSE command by itself, the browse window opens without the error message.
>
>Any ideas?
>
>TIA
>
>Richard W. Bates
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform