Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Kind of like an incremental search?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00176662
Message ID:
00176689
Vues:
28
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform