Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
String question on search screen
Message
De
20/06/1998 19:07:41
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
 
À
19/06/1998 15:01:11
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00110033
Message ID:
00110291
Vues:
18
>I'm using the following code:
>
>str3=""
>
>If not empty(this.value)
>str3 = "upper(client.surname) like '" + allt(upper(this.value)) + "%'"
>Endif

This may be a workaround - just forbid square brackets and let them keep the apostrophes:

If not empty(this.value)
str3 = "upper(client.surname) like [" + allt(upper(this.value)) + "%]"
Endif

and in the textbox keypress, add this

if inlist (nKeyCode, 91, 93)
nodefault
endif

Nobody I know uses chr(91) or chr(93) as regular part of the name, and they are just regular string delimiters in VFP.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform