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.