getformulatext
getformulatext
TEMPLATE
,
FORMULA

The getformulatext statement converts a formula into text without special quote characters.

Parameters

This statement has two parameters:

template – Name of field or variable to store text of formula.

formula – Formula.

Description

Many statements require a formula as text, which usually requires using special quote characters like “ ” or { }. This can get confusing. The getformulatext statement allows you to convert a formula into text without special quote characters.

This procedure will display `"2+2"`

    local myFormula
    getformulatext myFormula,2+2
    message myFormula

See Also

- Diagnosing a Formula embedded in a Form Object -- diagnosing problems with formulas embedded in form objects.
- formulatokencount( -- returns a count of the number of tokens in a formula.
- grabformula -- evaluates a formula using data from another database.

History

Version | Status | Notes
10.0 | No Change | Carried over from Panorama 6.0.