Invalid formula: Unknown function/operator

HCL Domino Domino Forum
1

Hi there,

I have created a button that picks up subforms based on the users selection using @prompt.

The user is receiving the “Invalid formula: Unknown function/operator” message when trying to execute this action. I have created this database under 6.5 (which works perfectly fine and the user is using 5.1 …

Is this a possible cause? and is there a way around this?

Here’s my code:

FIELD requesttype := requesttype;

FIELD type := type;

requesttype := @Prompt([OkCancelEditCombo] : [NoSort]; “Please select Request type”; “Request Type.”; " Access Request and Password Reset" ; “Access Request and Password Reset” : “Mailcode Address Change” : “New Report Setup” : “Report Distribution Change Request” : “Reprint Request” : “Mandatory Report Reprint Form” : “Other Not Listed” );

@SetField(“type”; requesttype);

@Command([ViewRefreshFields])

2

Subject: Invalid formula: Unknown function/operator

your code works fine for me in 6.5.1. I don’t have R5 to test with but you may want to post this in the R5 forum.

3

Subject: Invalid formula: Unknown function/operator

I’m guessing that [NoSort] was addin in 6.0, so will fail for R5 user.

4

Subject: Invalid formula: Unknown function/operator

Thanks Everyone! I’ll keep your suggestions in mind! Greatly appreciated. I think I know what is causing the error, which is new to lotus 6.

5

Subject: Invalid formula: Unknown function/operator

Claire, luckily for you, I was too lazy to remove my R5 install from my laptop and opened it up for the first time in 2 years. Following up on the posts from Ben and Paul, it looks like [NoSort] was around in R5. That was my first guess too. And your code ran fine in R5, so that does not appear to be the problem.

I’m guessing since the last thing you do is @Command([ViewRefreshFields]); could there be an R6 formula in one of the other fields on the form that may be causing the error? Try removing the refresh and see if the error still comes up. At least that will narrow down the problem, a bit.

Just some advice: when developing in a mixed release client environment, you should use the “lowest common denominator” rule. R5 code will work on R6 but not necessarily vice versa. I know its no fun that way but that’s how you can avoid problems like this.

Hope that helps.