Hello - I receive a message stating - “Invalid formula: unknown function/operator” when I open a form with this formula (I isolated the problem to this formula). Why would this work in R6, but not R5. I am accessing the same database on the same server with each client. Any help is appreciated.
Formula in question -
@IfError(@DbLookup (“”:“”;“”:“”;“ExceptionSortView”;Exception;“Description”);“”)
Subject: @dblookup works in R6 not in R5
I would suggest you read the help file in Designer 6 and not use ND6 only functions for applications that are still used by R5 clients (@IFError).
Subject: @dblookup works in R6 not in R5
This is from ages ago, but I am guessing the user meant to use @IsError instead of @IfError…
Subject: RE: @dblookup works in R6 not in R5
No, there is/was an @IfError. It was introduced with ND6 (which explains why it wouldn’t work in R5). It never did work quite as it should have, and has been obsoleted in ND7. Instead of this:
temp := @DbLookup(blah);
@If(@IsError(temp);defaultvalue;temp)
or worse:
@If(@IsError(@DbLookup(blah));defaultvalue;@DbLookup(blah))
(which happened FAR too often, and was probably the inspirartion for the new function), you would do:
@IfError(@DbLookup(blah);defaultvalue)
which was equivalent to the first construct. In theory. Had it not been flaky.
Subject: It’s not the @DbLookup, it is the @IfError function that is not known in R5