Table field methods
Table fields provide the following methods:
Clear()
The Clear() method sets the field to its cleared value. The following table lists the cleared value for standard datatypes:
Datatype |
Cleared value |
|---|---|
Date |
0/0/0 |
Currency |
0 |
Integer |
0 |
Long |
0 |
String |
Empty string |
Time |
000000 which corresponds to 12:00:00 AM |
Fill()
The Fill() method sets the field to its filled value. 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 |