Hi Glenn,

I did as you suggested, but I still get the error.

I CAN edit and save it successsfully, in the View Editor utility, but, ugh, would like to be able to edit it in the VFP view designer! I guess we don't alway get what we want...looks like a bug to me.

Thanks for your input...if anyone eles has a suggestion, i'd love to hear it.

J
>Hello Jill,
>
>The first thing I would do is shorten the table aliases like this

>Select CR_M.mas_ssnock As payeessno,;
>	CR_M.mas_last As payeelast, CR_M.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),T_A.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(WE_M.mas_ssnock),Space(9),Transform(WE_M.mas_ssnock,"@R 99-999999")) As wessno,;
>	NVL(WE_M.mas_last,Space(25)) As welast,;
>	NVL(WE_M.mas_first,Space(35)) As wefirst,;
>	IIF(Isnull(BE_M.mas_ssnock).Or.Empty(BE_M.mas_ssnock),Space(9),Transform(BE_M.mas_ssnock,"@R 99-999999")) As bessno,;
>	NVL(BE_M.mas_last,Space(25)) As belast,;
>	NVL(BE_M.mas_first,Space(35)) As befirst,;
>	T_A.mis_addeddate, T_A.mis_addedby,;
>	T_A.mis_changeddate,;
>	T_A.mis_changedby, T_A.mis_pk,;
>	DTOS(Nvl(claim.cla_onsetdate,{})) As dtosonset,;
>	DTOS(mis_addeddate) As dtosadddat,;
>	DTOS(mis_changeddate) As dtoschgdat, T_A.mis_claimfk,;
>	T_A.mis_initialorls;
>	FROM ;
>	sa!Miscellaneouschecks T_A ;
>	LEFT Outer Join sa!claim ;
>	ON  T_A.mis_claimfk = claim.cla_pk ;
>	INNER Join sa!Master CR_M ;
>	ON  T_A.mis_payeemasterfk = CR_M.mas_pk ;
>	LEFT Outer Join sa!Master BE_M ;
>	ON  T_A.mis_BE_Mfk = BE_M.mas_pk ;
>	LEFT Outer Join sa!Master WE_M ;
>	ON  claim.cla_WE_Mfk = WE_M.mas_pk
>

>
>
>>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.
>>
>>But, also the following works:
>>

CAST(IIF(ISNULL(cla_pk),mis_amount,IIF(cla_lumpsumamt=0,cla_initialamt,cla_lumpsumamt)+cla_initialorlsamtadjustment) AS N(9,2)) AS amount,;

>>
>>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