Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Characters
Message
De
04/09/2008 04:19:57
 
 
À
04/09/2008 03:15:21
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Divers
Thread ID:
01344739
Message ID:
01344743
Vues:
10
This message has been marked as a message which has helped to the initial question of the thread.
Create a string of all legal characters, and compare it to the field value
lcLegal=[abcedefghijklmnopqrstuvwxyz0123456789.,'" ] + upper([abcedefghijklmnopqrstuvwxyz]) 
*You must modify the previous line to fit your need
if !empty(chrtran(fieldx,lcLegal,'')) && the field contains illegal data
  replace field2 with 111
else
  replce field2 with 1
endif
>hi all,
>
>if the field have data as 123456Arabic characters as (568329 ???)
>  replace field2 with 111
>else
>replce field2 with 1
>endif
>
>thank for help
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform