Notes/Domino Fix List
SPR # KOZI5N2DVBFixed in 6.0.3; 6.5 releaseRegression in 6.0



Product Area: Designer; R5/R6 Interoperability Technical Area: @functions Platform: Cross Platform

SPR# KOZI5N2DVB - When using @TextToNumber(FieldText) as part of a View Selection formula in R5.x, the documents are displayed as they should. In R6.02 documents are no longer displayed. This problem was a regression introduced in 6.0 and fixed in 6.0.3, 6.0.2 CF2 and 6.0.1 CF3.

Technote Number: 1107706

Problem:
This issue was reported to Lotus Software Quality Engineering and was resolved
in Notes/Domino 6.0.1 CF3 and Notes/Domino 6.0.2 CF2. The issue is also
addressed in Notes/Domino 6.0.3 and Notes/Domino 6.5.

Excerpt from the Lotus Notes and Domino Release 6.0.1 CF3 and 6.0.2 CF2 MR fix
lists (available at http://www.lotus.com/ldd):

@functions
SPR# MGAN5LQLB3 - Expressions evaluating to @error, when used in a numeric
comparison, return results consistent with R4/R5. This problem was introduced
in 6.0.

SPR# NNYU5MGPTE - Comparing a formula expression which evaluates to @error,
with a numerical value, the formula evaluates to @error. This regression was
introduced in 6.0.

SPR# KOZI5N2DVB - When using @TextToNumber(FieldText) as part of a View
Selection formula in R5.x, the documents are displayed as they should. In R6.02
documents are no longer displayed. This problem was a regression introduced in
6.0.

SPR# ATAI5MGAEJ - In the previous releases (R4.6/R5), if an @ERROR was compared
against a value (numerical or string) it always returned @ERROR. However in R6,
it either returns a numerical value of 1 or 0 depending on which comparison
operators are used. @error will now function as it did in R5.

Recommended coding practice:
In all Notes/Domino Designer releases it is recommended that the @IsError
function be used to check whether a formula evaluates to Error and handle as is
necessary for the application.

For example, rather than using the following formula (to deal with a blank
entry in a text field being converted to a number):

@If(@TexttoNumber(fielda)<1; 0 ; @TexttoNumber(fielda))

you should use:

echeck := @TexttoNumber(fielda);
@If(@IsError(echeck); 0; echeck)


Note: There is an issue with the @IfError function which is not resolved by
the fixes discussed in this document. For more information on that issue see
the following document:

"@IfError Does not Work when Passed Mathematical @Formulas or Equations which
Result in an Error"
Document #: 1148392


Supporting Information:
In Notes R5 a conditional that contains an element which evaluates to Error
results with the comparison having a value of Error, and the True condition is
executed.

In Notes 6 if a comparison is done, as in the first example above, then
depending on the conditional either the True or False may be executed. This is
because the Error result in Notes 6 has a positive numeric value associated
with it. As seen in the second example above, the comparison results in the
Else condition being executed because Error is not less than 1.

In both Notes R5 and Notes 6 if there is no comparison done in the conditional
then the Then condition is executed. This can be observed in the third example
above.
More >



Last Modified on 01/21/2005

Go back