I
IIF(expI,eExp1,eExp2)
Data Format Returned: Character, Numeric, Currency, Date, or DateTime
Returns one of two values depending on the value of a logical expression.
Parameters
Variable | Description |
---|---|
ExpI | Specifies the
logical expression that IIF( ) evaluates.
|
eExp1 | If ExpI
evaluates to true (.T. ), eExp1 is returned.
|
eExp2 | If ExpI
evaluates to false (.F. ), eExp2 is returned. |
Remarks
This function, also known as Immediate IF, evaluates a logical expression
and then returns one of two expressions. If the logical expression evaluates
to true (.T.), IIF( )
returns the first expression. If the logical expression evaluates to false
(.F.
), IIF( )
returns the second expression.
Use IIF()
to evaluate whether a 'Fire'
activity type is checked in results records that include activity detail
records. If 'Fire' is checked, the expression is True
.
IIF(act_det.fire,'Yes',' ')
only displays
'Yes'
if the field returns a True
.
IIF(act_det.fire,' ','No')
, only displays
'No'
if the field returns a False
.
IIF(act_det.fire,'Yes','No')
, displays
either 'Yes'
or 'No'
depending on the what value is returned from the
field. 'Yes'
if the field is true. 'No'
if the field is false.
Note: You can evaluate expressions using criteria operators.
Example: IIF(act_det.hours > 1,'Yes','No')
,
'Yes'
would only be returned if the value in the Hours field of an activity detail was greater than 1.
IncidentDescription(expC1,expC2)
Data Format Returned: X
Returns
a description of an incident based on its system-generated incident ID
value. The value returned is FDID
, Alarm Date
, and Incident
Number
.
Parameters
Variable | Status | Description |
---|---|---|
expC1 | Required | Name of table where the incident is entered.
This parameter must be either INC_MAIN or EMS_MAIN .
|
expC2 | Required | The ID value of the incident to query. |
IncidentDescription('inc_main',Lst.Inci_id)
returns 20007 01/01/01 01-0000001-000
.
INT(expN)
Data Format Returned: N
INT returns just the integer portion (whole number) of a numeric field.
Parameters
Variable | Description |
---|---|
expN | specifies the numeric expression for which INT( ) returns the integer portion. |