QueryDBRecordField Class Properties
In this section, we discuss the QueryDBRecordField class properties. The properties are discussed in alphabetical order.
Description
This property returns the decimal positions for a field. This indicates how many numbers are allowed on the right side of the decimal.
This property is read-only.
Example
&FldDecs = &QryDBRcdFlds.Decimal;
Description
This property returns the long description of the field as a string.
This is property is read-only.
Description
This property returns the Use and Edit Flags of the field, which are set when the Field is defined in Application Designer, as a numeric value.
Values for Use Flags are:
Value |
Description |
---|---|
1 |
Key |
2 |
Duplicate Key |
4 |
System |
8 |
Audit Field Add |
16 |
Alternate Key |
32 |
List Item |
64 |
Descending Key |
128 |
Audit Field Change |
1024 |
Audit Field Delete |
2048 |
Search Item |
32768 |
Auto Update |
Values for Edit Flags are:
Value |
Description |
---|---|
256 |
Required |
512 |
Edit Translate |
4096 |
Date Range Edit |
8192 |
Yes/No Table Edit |
16384 |
Edit Table |
262144 |
From Search Field |
524288 |
Through Search Field |
8388608 |
Use Default Label Flag |
16777216 |
Default Search Field |
This is a read-only property.
Description
This property returns the field format for a field. Values are:
Value |
Description |
---|---|
1 |
No format |
2 |
Name |
3 |
Phone Number North America |
4 |
Zip/Postal Code North America |
5 |
Social Security Number (SSN) |
6 |
Uppercase |
7 |
Mixed case |
8 |
Raw binary |
9 |
Numbers only |
10 |
Canadian Social Insurance Number (SIN) |
11 |
Phone Number International |
12 |
Zip/Postal Code International |
13 |
Seconds |
14 |
Microseconds |
15 |
Custom |
This property is read-only.
Description
This property returns the length of the field as a number.
This property is read-only.
Description
This property returns the long name of the field as a string.
This property is read-only.
Description
If the field has a lookup table associated with it, this property returns the name of that Lookup Table, else it returns an empty string.
This is a read-only property.
Description
If the field has a lookup table associated with it, this property returns the instance of the QueryDBRecord for that Lookup Table, else it returns NULL.
This is a read-only property.
Description
This property returns the name of the field as a string.
This property is read-only.
Description
This property returns the short name of the field as a string.
This property is read-only.
Description
This property returns the type of the field. You can specify either a constant or a numeric value for this property. The values are:
Numeric Value |
Constant Value |
Description |
---|---|---|
0 |
%FieldType_Char |
Character |
1 |
%FieldType_LongChar |
Long Character |
2 |
%FieldType_Number |
Number |
3 |
%FieldType_SignedNumber |
Signed number |
4 |
%FieldType_Date |
Date |
5 |
%FieldType_Time |
Time |
6 |
%FieldType_DateTime |
DateTime |
8 |
%FieldType_Image |
Image |
8 |
%FieldType_File |
File |
9 |
%FieldType_ImageRef |
ImageReference |
Note: The Image and File types can be differentiated using the GetImageFormat method of the QueryField class.
This property is read-only.