Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
PAD TRANSFORM and IIF giving me compile error
Message
 
 
À
11/04/2008 08:59:24
Jay Johengen
Altamahaw-Ossipee, Caroline du Nord, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Divers
Thread ID:
01309915
Message ID:
01309919
Vues:
11
>This is a line from a SQL statement. I keep trying different things with parenthesis moved around, but I keep getting a compile error. Anything obvious? Forget that I don't need TRANSFORM on this line, but I will need it on other similar ones.
>
>
>PADR(THIS.Strip(TRANSFORM(IIF(Covr.Cvt='01','MediCare',IIF(Covr.Cvt='02','MediCaid','Other)), '@T')), 30, ' ') ;
>	AS IN1_15_00_Plan_Type, ;
>
Can you use ICASE - the code would be a bit simpler to read?

Also may be you can use my idea from your other thread, e.g.
*32 spaces in total for each word
lcListOfChoices = [  Other      01MediCare       02Medicaid     ]

this.strip(substr(m.lcListOfChoices,at(Covr.Cvt,m.lcListOfChoices)+2,30))
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform