Field Object

A Field object contains the properties for a field in the data dictionary. This object has no methods.

Properties

Name Data Type Description

AllowValues Boolean True if the Values button in Stonefield Query is enabled for this field.

Calculated Boolean True if this is a calculated field. If the SQExpression property of a calculated field is False, set this property to False as well.

Caption Character The caption for the field.

Comment Character The comment for the field.

Decimals Numeric The number of places after the decimal.

Exact Boolean If this property is True (which it is by default) and the user filters on this field, Stonefield Query adds blanks to the filter value when the "equals" operator is used so the search is exact.

Expression Character The expression to determine the value of this field if it's a calculated field.

FieldList Character A comma-delimited list of aliased field names used to calculate the value of this field if it's a calculated field. Leave this property blank if SQExpression is False.

FieldName Character The aliased name of the field. You don't have to fill in this property because that's done automatically when you add the field to the collection.

Filterable Boolean True if the user can filter on this field.

Format Character The format for this field.

Heading Character The default column heading for this field in a report.

Length Numeric The width of the field.

Other Character Stores user-defined information for the field; Stonefield Query doesn't use this property for anything but your scripts could.

OutputLength Numeric The output width of the field. You don't have to fill in this property unless it's different than Length.

OutputType Character The output data type of the field; see "Type" below for a list of valid data types. You don't have to fill in this property unless it's different than Type. Note setting this doesn't mean Stonefield Query converts the values in the data to the specified type; you are simply informing Stonefield Query what the data type of Expression is.

Picture Character The picture for this field.

Reportable Boolean True if the user can report on this field.

Roles Character A comma-delimited list of roles that can access the field (blank means everyone can access it).

Sortable Boolean True if the user can sort on this field.

SQExpression Boolean True if this calculated field uses a Stonefield Query expression; False if the expression is sent as is to the database engine.

Type Character A single character representing the data type of the field:
W: Blob
C: Character
Y: Currency
D: Date
T: DateTime
B: Double
G: General
I: Integer
L: Logical
M: Memo
N: Numeric
V: Varchar
Q: Varbinary

UserDefined Character Unless this field is defined as an enumerated field, this property can contain anything you want to place in it.

ValuesMethod Character The expression to use to display the unique values for this field. This should normally be left alone unless you need to do some specific processing to display the list of values.

Name	Data Type	Description
AllowValues	Boolean	True if the Values button in Stonefield Query is enabled for this field.
Calculated	Boolean	True if this is a calculated field. If the SQExpression property of a calculated field is False, set this property to False as well.
Caption	Character	The caption for the field.
Comment	Character	The comment for the field.
Decimals	Numeric	The number of places after the decimal.
Exact	Boolean	If this property is True (which it is by default) and the user filters on this field, Stonefield Query adds blanks to the filter value when the "equals" operator is used so the search is exact.
Expression	Character	The expression to determine the value of this field if it's a calculated field.
FieldList	Character	A comma-delimited list of aliased field names used to calculate the value of this field if it's a calculated field. Leave this property blank if SQExpression is False.
FieldName	Character	The aliased name of the field. You don't have to fill in this property because that's done automatically when you add the field to the collection.
Filterable	Boolean	True if the user can filter on this field.
Format	Character	The format for this field.
Heading	Character	The default column heading for this field in a report.
Length	Numeric	The width of the field.
Other	Character	Stores user-defined information for the field; Stonefield Query doesn't use this property for anything but your scripts could.
OutputLength	Numeric	The output width of the field. You don't have to fill in this property unless it's different than Length.
OutputType	Character	The output data type of the field; see "Type" below for a list of valid data types. You don't have to fill in this property unless it's different than Type. Note setting this doesn't mean Stonefield Query converts the values in the data to the specified type; you are simply informing Stonefield Query what the data type of Expression is.
Picture	Character	The picture for this field.
Reportable	Boolean	True if the user can report on this field.
Roles	Character	A comma-delimited list of roles that can access the field (blank means everyone can access it).
Sortable	Boolean	True if the user can sort on this field.
SQExpression	Boolean	True if this calculated field uses a Stonefield Query expression; False if the expression is sent as is to the database engine.
Type	Character	A single character representing the data type of the field: W: Blob C: Character Y: Currency D: Date T: DateTime B: Double G: General I: Integer L: Logical M: Memo N: Numeric V: Varchar Q: Varbinary
UserDefined	Character	Unless this field is defined as an enumerated field, this property can contain anything you want to place in it.
ValuesMethod	Character	The expression to use to display the unique values for this field. This should normally be left alone unless you need to do some specific processing to display the list of values.

See Also
Fields Collection | Field Properties