Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

formulas in data dictionary

Status
Not open for further replies.

johnjrd

MIS
Jun 6, 2001
54
GB
Hi

Im creating a dictionary and i need to use a few formulas which is easy enough, except that some of the formulas are quite long and go over the 1640 char limit. So I read thru a few things including knowledge base doc C2008073 and decide to split my formula into two and and have third formula which controls it
i.e.
formula 1

if field x = 1 then "Hello"
else if field x = 2 then "Bye"
.
.
else if field x = 23 then "See you later"
else "see next"

formula 2

if field x = 24 then "Hi"
else if field x = 25 then say "Goodbye"
.
.
else if field x = 50 then say "See you around"

formula c

if formula 1 = "see next"
then formula 2
else formula 1

now all of this seems straight forward but the problem is when i do this the dictionary doesnt seem able to reference formula 1 and 2 and i get a field not found error

is there some way i have to name the formulas ?
How do i reference these formulas from within the dictionary ?

any suggestions would be welcome

help
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top