Hello all,
could you please know how to debug the formula language:
i think there is one remedy is there: i dont know excatly.
i think it was in earlier version:
l know @prompt and all this stuff
is there any way like we can do in LotusScript:
Regards,
Dev Chauhan
Subject: Debugging formula
Have you considered @CheckFormulaSyntax:@CheckFormulaSyntax(formulaText)
Parameters
formulaText
Text. The formula code to test for errors, commented out. Enclose the formula code in braces ({}) to comment out the code.
Return value
errorInformation
Text or textlist.
Returns “1” if the formula has no errors.
Returns the text list “errorMessage” : “errorLine” : “errorColumn” : “errorOffset” : “errorLength” : “errorText” where each list item is defined as follows:
errorMessage: Message returned by the compiler.
errorLine: Line where the error occurred, beginning with 1, not zero. New lines created by wrapped text are not counted.
errorColumn: Number of character spaces from the first character in the line where the error occurred, beginning with 1.
errorOffset: Number of character spaces from the first character in the formulaText block where the error occurred, beginning with 1.
errorLength: Length of the text making up the error.
errorText: Text or token that the compiler processes as the cause of the error.
Usage
This @function reports compile errors, not run-time errors. A run-time error is generated, for example, if a function has an insufficient number of arguments. This function is useful especially if you are using the @Eval function to execute a text expression at run-time, since you can use it to first check the syntax of any text you supply to @Eval.
Otherwise, you could use the Evaluate function in LS, and put the formula in there?
Subject: RE: Debugging formula
We used to have a formula debugger, but then we changed some of the internals of how formulas worked and haven’t had time to update this tool to make it work with the new paradigm.
Subject: RE: Debugging formula
Could you please tell me the tool you had used?
Dev
Subject: RE: Debugging formula
Dev, the formula debugger was build into Notes R5, but it’s no longer there in Notes 6 and up. It never was a supported or even documented offering, and if you ask me, it’s gone for good (although others disagree).
One easy way to display variable values in formulas in 6 and up without having to click through dozens of prompt boxes, is to use @StatusBar. Whatever you pass it, will be written to the status bar of your Notes client. Set the status bar properties to display more than the default of 20 lines, and you have a fast and simple tool for displaying whatever text values in your formulas. You still have to add - and later remove - the @StatusBar calls (or have to come up with some debug flag, e.g. a notes.ini variable, that you can use to determine, if the status bar messages should be displayed or not).