Composite field properties
Composite fields have the following properties:
IsEmpty
The IsEmpty property returns the value true when the value of the composite field is empty for the specific field type. The following table lists the empty value for standard datatypes:
Datatype |
Empty value |
|---|---|
Date |
0/0/0 |
Currency |
0 |
Integer |
0 |
Long |
0 |
String |
Empty string |
Time |
000000 which corresponds to 12:00:00 AM |
IsFilled
The IsFilled property returns the value true when the value of the composite field is set to the maximum value for the specific field type. The following table lists the filled value for standard datatypes:
Datatype |
Filled value |
|---|---|
Date |
12/31/9999 |
Currency |
99999999999999.99999 |
Integer |
32,767 |
Long |
2,147,483,647 |
String |
The length byte (first byte) of the string is set to the storage size of the string minus 1. Each of the remaining bytes is set to string equivalent of ASCII 255. |
Time |
23:59:59 |
Length
The Length property is used to retrieve the number of components in the composite field.
Value
The Value property is used to set or retrieve the value of the composite field. The IntelliSense in Visual Studio will tell you what type of value is used for the field.