>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