Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
10 numbers
Message
De
09/09/2008 12:18:31
 
 
À
09/09/2008 04:46:26
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:
01345962
Message ID:
01346097
Vues:
11
>Have you ever seen the syntax Scan-else-Endscan? It's new to me. The bottom line is that it will give an error, and even if VFP would not catch the error, the Else statement would never execute since the scan already excluded those records.
>

To say nothing of the fact that
"string" = ""
is always true


>>Why not?
>>
>>no # id_no
>>
>>Agnes
>>>Your code won't work!
>>>scan 
>>>  if LEN(ALLTRIM(id_no))==10 AND CHRTRAN(ALLTRIM(id_no),"1234567890","")==""
>>>    replace no WITH 111
>>>  else &&error
>>>    replace no WITH 1
>>>  endif
>>>endscan
>>>
>>>
>>>>thank you it works
>>>>
>>>>i need to use it as below
>>>>
>>>>scan FOR LEN(ALLTRIM(id_no))==10 AND CHRTRAN(ALLTRIM(id_no),"1234567890","")==""
>>>>    replace no WITH 111
>>>> else &&error
>>>>    replace no WITH 1
>>>>endscan
>>>>
>>>>
>>>>thanks
>>>>>Hi,
>>>>>
>>>>>>if the data (exactly 10 numbers) as 1562907543
>>>>>
>>>>>IF LEN(ALLTRIM(data))==10 AND CHRTRAN(ALLTRIM(data),"1234567890","")==""
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform