I have the exact same problem as this person
Has anyone have any idea why even this is happening?
IRIS? Anyone? Please help!
Eliese
x
Subject: RE: @Subset problem with r5 app on r6 client- IRIS?
The post you linked to does not contain enough information to make a determination of the problem. That’s probably why nobody answered.
As far as I know, @Subset is unchanged. It has never accepted 0 as a second argument. I find it unlikely you’re using the exact same formula this person was. Whatever formula you’re using, please post the formula. If you’re getting an error message, please post the error message, in full. Please read the following information about debugging formulas: http://www-10.lotus.com/ldd/today.nsf/0/a2b75e1747c115c285256d6e00602957?OpenDocument
Make sure that you know exactly where the problem is happening. Don’t assume that it’s with @Subset just because someone else said they had a problem with @Subset. Their problem was not with @Subset. Clauses of an @If aren’t evaluated if their conditions don’t test true. If what they were saying is accurate, they were having some other problem, but since they didn’t post the error message or do any debugging, nobody could guess what it might be.
Subject: RE: @Subset problem with r5 app on r6 client- IRIS?
Sometimes I think people who know me must post things like this under an assumed name, just to see how I’ll react.
Your problem is not with @Subset or @If – they are both working exactly as they alwas did. It would probably benefit you to put debugging code in the formula to see exactly what’s going wrong. I kind of suspect it might have more to do with the date than the version of Notes, but if you just want to solve the problem, read on.
First, I don’t know what the value of Prepayment_Start_Month is as you go into your long formula. You say you get the error when composing, which makes me think the main problem may be that Prepayment_Start_Month_Dsp comes before Prepayment_Start_Month on the form, so that as you’re composing the document, Prepayment_Start_Month is blank when the long formula is evaluated. Please make sure Prepayment_Start_Month comes first.
Second, the default formula for a keyword field with aliases should be the alias value, not the display value. The aliasing of values isn’t applied immediately when the field is assigned by a formula, so the Prepayment_Start_Month_Dsp formula would have a funny value like “Jun 04” to work with, which is likely to mess it up.
Third, there’s no need for this huge @If statement which will eventually fail when it runs out of years anyway. How about this instead?
_monthNum := @TextToNumber(Prepayment_Start_Month) - 1;
_monthName := @Select(@Modulo(_monthNum; 12) + 1; “Jan”; “Feb”; “Mar”; “Apr”; “May”; “Jun”; “Jul”; “Aug”; “Sep”; “Oct”; “Nov”; “Dec”);
_yearNo := @Integer(_monthNum/12) + 2;
_tmp := _monthName + " " + @Right(“0” + @Text(_yearNo); 2);
@If(@IsError(_tmp); “”; _tmp)
Fourth, how sure are you about your keyword formula that supposedly sets up these month aliases? Perhaps you’d better check what values it’s actually producing, also! Is it possible that that formula breaks when the month is June '04?
Subject: RE: @Subset problem with r5 app on r6 client- IRIS?
That’s nice… soo helpful… Great of you to assume that nothing has changed … does anyone else really think that nothing changes in the evaluation of formulas or compilation/execution of Lotus script between releases or just the people at IBM/Lotus??
I too am receiving the @Subset error even in code that should be skipping the @Subset with the evaluation of @True. Example:
@If(@True; “ID1”; @Subset(testList;0));
The @Subset error still shows even though the @Subset should not be executed. In the case where a variable or field is used instead of it being specified as 0, how am I supposed to avoid the computation of @Subset?
This also displays the error:
testNum := 0;
thisID := @If(testNum=0;“Test”; @Subset(testList;testNum));
Shouldn’t that be preventing the error?
Subject: RE: @Subset problem with r5 app on r6 client- IRIS?
Hi,
I hope you are still reading this thread…
My application worked using an r5 client but not r6.
The code is
FIELD Prepayment_Start_Month :=Prepayment_Start_Month;
Prepayment_start_month_number := @TextToNumber(Prepayment_Start_Month);
month_list :=“Jan”:“Feb”:“Mar”:“Apr”:“May”:“Jun”:“Jul”:“Aug”:“Sep”:“Oct”:“Nov”:“Dec”;
@If (Prepayment_Start_month =“”;“”;
@Do(
@If (Prepayment_start_month_number <13;@Subset(@Subset(month_list;Prepayment_start_month_number );-1)+ " 02";
Prepayment_start_month_number <25;@Subset(@Subset(month_list;Prepayment_start_month_number -12);-1)+ " 03";
Prepayment_start_month_number <37;@Subset(@Subset(month_list;Prepayment_start_month_number -24);-1)+ " 04";
Prepayment_start_month_number <49;@Subset(@Subset(month_list;Prepayment_start_month_number -36);-1)+ " 05";
Prepayment_start_month_number <61;@Subset(@Subset(month_list;Prepayment_start_month_number -48);-1)+ " 06";
Prepayment_start_month_number <73;@Subset(@Subset(month_list;Prepayment_start_month_number -60);-1)+ " 07";
Prepayment_start_month_number <85;@Subset(@Subset(month_list;Prepayment_start_month_number-72);-1)+ " 08";
Prepayment_start_month_number <97;@Subset(@Subset(month_list;Prepayment_start_month_number -84);-1)+ " 09";
Prepayment_start_month_number <109;@Subset(@Subset(month_list;Prepayment_start_month_number -96);-1)+ " 10";
Prepayment_start_month_number <121;@Subset(@Subset(month_list;Prepayment_start_month_number -108);-1)+ " 11";
@Subset(@Subset(month_list;Prepayment_start_month_number -120);-1)+ " 12")))
When a user with an r6 client tries to create a document, it gives the error
“Field: Prepayement_Start_Month_Dsp: The second argument to @Subset must not be zero”
The default value for Prepayment_Start_Month (a dialog list with aliases) field is
month_list :=“Jan”:“Feb”:“Mar”:“Apr”:“May”:“Jun”:“Jul”:“Aug”:“Sep”:“Oct”:“Nov”:“Dec”;
todays_month :=@Subset(@Subset(month_list;@Month(@Now));-1);
todays_year :=@Right(@Text(@Year(@Now));2);
todays_month+" " +todays_year
Which for today would equal “Jun 04” | “30” (as there are aliases set up for each date value- Jan 02=1 Feb 02=2… June 04= 30) So the Prepayement_Start_Month_Dsp field should be
“June 04”
But it gives this error.
I hope there is enough there to help me solve this prob
Thanks
Eliese