Nope, that fails too!

>You can also try ICASE instead of IIF.
>
>>Jill,
>>
>>We just had the same problem in VFP8. It was a simple create table command, so this error was very strange. Anyway, once I shortened this statement, I was able to run it. In you case you may try
>>

>>text to lcSQL noshow
>>select statement
>>endtext
>>
>>&lcSQL
>>

>>
>>>Hi,
>>>
>>>I'm getting a "Line is too long" error when changing a view definition. I think it's related to the CAST, since when i remove it, I don't get the error.
>>>
>>>In order words, when defining the amount field to be:
>>>

CAST(IIF(ISNULL(cla_pk).OR..NOT.mis_initialorls,mis_amount,IIF(cla_lumpsumamt=0,cla_initialamt,cla_lumpsumamt)+cla_initialorlsamtadjustment) AS N(12,2)) AS amount, ;

>>>
>>>I get the error. The entire view definition, w/no error, follows:
>>>

SELECT Crmaster.mas_ssnock AS payeessno,;
>>>  Crmaster.mas_last AS payeelast, Crmaster.mas_first AS payeefirst,;
>>>  IIF(ISNULL(cla_pk).OR..NOT.mis_initialorls,mis_amount,IIF(cla_lumpsumamt=0,cla_initialamt,cla_lumpsumamt)+cla_initialorlsamtadjustment) AS amount,;
>>>  IIF(.NOT.ISNULL(cla_pk),Miscellaneouschecks.mis_fund,cla_fund) AS fund,;
>>>  IIF(ISNULL(cla_pk),SPACE(10),TRANSFORM(cla_numberck,"@R 99-99-9999")) AS claim,;
>>>  NVL(Claim.cla_bentype,SPACE(2)) AS benefittype,;
>>>  NVL(Claim.cla_onsetdate,{}) AS onsetdate,;
>>>  CAST(IIF(ISNULL(Claim.cla_lumpsumamt),0,IIF(mis_initialorls,Claim.cla_lumpsumamt,0)) AS N(9,2)) AS lumpsumamount,;
>>>  CAST(IIF(ISNULL(Claim.cla_initialamt),0,IIF(mis_initialorls,Claim.cla_initialamt,0)) AS N(9,2)) AS initialamount,;
>>>  CAST(NVL(Claim.cla_initialorlsamtadjustment,0) AS N(9,2)) AS adjustment,;
>>>  IIF(ISNULL(Wemaster.mas_ssnock),SPACE(9),TRANSFORM(Wemaster.mas_ssnock,"@R 99-999999")) AS wessno,;
>>>  NVL(Wemaster.mas_last,SPACE(25)) AS welast,;
>>>  NVL(Wemaster.mas_first,SPACE(35)) AS wefirst,;
>>>  IIF(ISNULL(Bemaster.mas_ssnock).OR.EMPTY(Bemaster.mas_ssnock),SPACE(9),TRANSFORM(Bemaster.mas_ssnock,"@R 99-999999")) AS bessno,;
>>>  NVL(Bemaster.mas_last,SPACE(25)) AS belast,;
>>>  NVL(Bemaster.mas_first,SPACE(35)) AS befirst,;
>>>  Miscellaneouschecks.mis_addeddate, Miscellaneouschecks.mis_addedby,;
>>>  Miscellaneouschecks.mis_changeddate,;
>>>  Miscellaneouschecks.mis_changedby, Miscellaneouschecks.mis_pk,;
>>>  DTOS(NVL(Claim.cla_onsetdate,{})) AS dtosonset,;
>>>  DTOS(mis_addeddate) AS dtosadddat,;
>>>  DTOS(mis_changeddate) AS dtoschgdat, Miscellaneouschecks.mis_claimfk,;
>>>  Miscellaneouschecks.mis_initialorls;
>>> FROM ;
>>>     sa!miscellaneouschecks ;
>>>    LEFT OUTER JOIN sa!claim ;
>>>   ON  Miscellaneouschecks.mis_claimfk = Claim.cla_pk ;
>>>    INNER JOIN sa!master Crmaster ;
>>>   ON  Miscellaneouschecks.mis_payeemasterfk = Crmaster.mas_pk ;
>>>    LEFT OUTER JOIN sa!master Bemaster ;
>>>   ON  Miscellaneouschecks.mis_bemasterfk = Bemaster.mas_pk ;
>>>    LEFT OUTER JOIN sa!master Wemaster ;
>>>   ON  Claim.cla_wemasterfk = Wemaster.mas_pk

>>>
>>>TIA for any help! J