If Then question 1

[RJMullins]

I am trying to create a report that gets the data from a Pervasive SQL database, I want to replace the empty value of one field with data I enter into the formula dependant upon the value of another field.

Example I have is:

if {Part_Master.ACTTYP_01} = "B" then {Part_Master.UDFKEY_01} = "0146BI";

But the result I am getting is True or False.

I have taken programming courses for my degrees however I have been a Network Engineer for too many years to remember any real programming language so any help is greatly appreciated!

Thanks

- Bob

 

[synapsevampire]

Try:

if {Part_Master.ACTTYP_01} = "B" then
"0146BI"

Thsi doesn't check for empty data though, that would look something like:

if isnull({Part_Master.ACTTYP_01})
or
{Part_Master.ACTTYP_01} = "" then
"Some value"
else
{Part_Master.ACTTYP_01}

-k

 

[RJMullins]

Thanks a million that worked.

- Bob