Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Test for ! empty fails
Message
De
18/08/2016 12:08:44
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Database:
MS SQL Server
Divers
Thread ID:
01639633
Message ID:
01639635
Vues:
115
This message has been marked as a message which has helped to the initial question of the thread.
Hi Naomi,

using VFP9
FOR NOT EMPTY(trim(dc_crdno, chr(9), chr(10), chr(13), chr(32), chr(160)))
>Hi everybody,
>
>I have this simple code
>
>
>replace dc_crdno WITH REPLICATE("*",12) + RIGHT(ALLTRIM(dc_crdno),4) FOR NOT EMPTY(dc_crdno) && IN csrReport
>
>The problem is that I see just 12 * for some rows, so I assume that there may be some unprintable characters in that column. How can I make sure to either show 12* + 4 last digits or show empty value?
>
>Thanks in advance.
Thierry Nivelet
FoxinCloud
Give your VFP application a second life, web-based, in YOUR cloud
http://foxincloud.com/
Never explain, never complain (Queen Elizabeth II)
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform