Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Kind of like an incremental search?
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00176662
Message ID:
00176687
Views:
22
I do the following FILTER condition builder for numerous form texboxes, but here is one form textbox input for example:

pcCondition = " "
IF NOT EMPTY(THISFORM.t_address.Value)
pcCondition = pcCondition + 'mytable.addr = THISFORM.t_address.Value + AND'
ENDIF

Then later I do the following:
SELECT mytable
SET FILTER TO &pcCondition
SCAN FOR &pcCondition
...
...
...
ENDSCAN

I guess I need something more than mytable.addr = THISFORM.addr.Value.

I don't do a SELECT or a SEEK. Sorry. I found this example in Miriam Liskin's Visual FoxPro Expert Solutions, Que.

Thanks for telling me about the command button color. I wondered why there was not a BackColor for command buttons. That would be a nice property for a command button to have.

Steve Kramer
Steve Kramer
Kramer & Kramer Design
"Home of Go Cartoons"
Web Site: www.stephenkramer.com
Would you believe Far Side Lite?
More than 270 original cartoons.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform