F
FieldInfo(expC1,expC2,expC3)
Data Format Returned: X
Returns information about a field in a table.
Parameters
Variable | Status | Description |
---|---|---|
expC1 | Required | The name of the physical table or the alias of the query containing the field. |
expC2 | Required | The name of the field to return information for. |
expC3 | Required | An expression
containing the name of the value to return. Valid options are CAPTION ,
SEQUENCE , DATA_TYPE , LENGTH , DECIMALS .
Sequence refers to the fields position in the table or the query fields
list. |
FindInAlias(expC1,expC2)
Data Format Returned: R
Does
not return a display value, but useful in reports to locate a record based
on qualifying expression. The alias specified must be in use and a qualifying
expression must be specified. The function will return true (.T.
)
if a qualifying record is found, or false (.F.
)
if not.
Parameters
Variable | Status | Description |
---|---|---|
expC1 | Optional | Name of alias in which to find record. If not passed, currently selected alias is assumed. |
expC2 | Required | Qualifying expression. |
FIPSCo(expC1,expC2)
Data Format Returned: X
Attempts to locate a FIPS county code for a specified state and county name .
Parameters
Variable | Status | Description |
---|---|---|
expC1 | Required | The two letter abbreviation for the state in which the county exists. |
expC2 | Required | County name to find. This function performs a case insensitive search for this county name in the state specified by expC1. A match is found if the name string passed is found anywhere within the county name specified in the lookup table. |
FIPSState(expC)
Data Format Returned: X
Attempts to locate a FIPS state code for a specified two-letter state abbreviation.
Parameters
Variable | Status | Description |
---|---|---|
expC | Required | The two letter abbreviation for the state to return the FIPS state code for. |
FiscalYear(expD,expN)
Data Format Returned: X
Returns the fiscal year for a specified date value. Return value can be either a 4-character string for the year or the numeric value of the year.
Parameters
Variable | Status | Description |
---|---|---|
expD | Required | The date value to return the fiscal year for. |
expN | Optional | Determines the type of data returned. If passed as zero (0) or not passed, the return value is a 4-character string. If passed as 1, returns the numeric value of the fiscal year. |
FiscalYearDate(expD,expN)
Data Format Returned: X
Returns either the starting date or ending date of the fiscal year in which a date value resides.
Parameters
Variable | Status | Description |
---|---|---|
expD | Required | The date value to return the fiscal year starting or ending date value for . |
expN | Optional |
Numeric value indicating the value to return .
If not passed, 1 is assumed. |
FLOOR
Data Format Returned: N
Round down to the next lower integer. Rounds a positive number with a fractional portion down to its integer value, and rounds a negative number with a fractional portion down to the next lowest integer.
FmtName(expC1,expC2,expC3,expC4)
Data Format Returned: X
Returns a formatted individual name string in the format Last Name, First NameMiddle.
Parameters
Variable | Status | Description |
---|---|---|
expC1 | Optional | Alias name contain individual name fields. If not passed, currently selected alias is assumed |
expC2 | Optional | Name of field in alias corresponding to last name. If not passed, LAST is assumed |
expC3 | Optional | Name of field in alias corresponding to first name. If not passed, FIRST is assumed |
expC4 | Optional | Name of field in alias corresponding to middle name. If not passed, MIDDLE is assumed |
FmtName(Contact)
returns last
name, first name M for the query alias “contact” (Occupancy Contacts report).
The name fields need to be a part of the query.