, ,

---

The grabformula statement evaluates a formula using data from another database.

---

Parameters

This statement has three parameters:

database – Database name.

formula – Text of formula.

result – Output value

---

Description

This statement evaluates a formula using data from another database.

This example assumes that the database has fields named Name, City and State (or fileglobal variables).

local label
grabformula "My Contacts",{Name+cr()+Address+cr()+sandwich("",City,", ")+State+" "+Zip},label

In this case the end result will look like a mailing address.

Jack Wilson
146 Orange Grove Place
Pasadena, NM 40983

---

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.
• getformulatext -- converts a formula into text without special quote characters.

---

History

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