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:01:20
 
 
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:
01309917
Views:
12
This message has been marked as the solution to the initial question of the thread.
Missing a quote after Other.

>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, ;
>
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform