Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
PAD TRANSFORM and IIF giving me compile error
Message
From
11/04/2008 09:14:54
 
 
To
11/04/2008 08:59:24
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01309915
Message ID:
01309919
Views:
10
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform