Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Force field content
Message
De
11/09/2008 06:21:26
 
 
À
11/09/2008 06:03:47
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Divers
Thread ID:
01346533
Message ID:
01346540
Vues:
9
No its not.

lcString = "ABCDEF"
?LEN(CHRTRAN(lcString,"ABCDEFGHIJKLMNOPQRSTUVWXYZ","")

0 = bad string all alpha

same with numbers.

I think you need something like

IF LEN(CHRTRAN(lcString,"ABCDEFGHIJKLMNOPQRSTUVWXYZ","") >0 AND LEN(CHRTRAN(lcString,"1234567890","") >0

string is ok



>Hi Moises,
>
>you could use regular expressions, but if there is no special position for numbers and letters you could do sometghing like this:
>
>lcString = "7CM4991"
>?LEN(CHRTRAN(lcString,"0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ","")
>
>In case of LEN() = 0 your String is OK.
>
>>I have a field
>>
>>Suppose use enter data to the field, as would like the behaivor as below:
>>
>>"ABDF"
>>= messagebox ("Field must contain numbers and letters")
>>
>>"8887"
>>= messagebox ("Field must contain numbers and letters")
>>
>>7CM4991
>>= messagebox ("OK")
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform