I
IIF
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.
Example
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
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. |
Example
IncidentDescription('inc_main',Lst.Inci_id)
returns 20007 01/01/01 01-0000001-000.
INT
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. |