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:
00176689
Views:
27
>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.

I don't want to comment on famous VFP expert example, but in VFP filter will give you more troubles than help. You should use SELECT-SQL or SEEK, so whatever I said in previous reply still applicable. Just one note: when you generate 'filter' (actually WHERE clause of SELECT) apply ALLTRIMs on all character entries.

>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.

Again, it's impossible because it's Windows setting (at least some VFP control can be truly Win control :).
Edward Pikman
Independent Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform