The fill table statement sets every field in the table buffer for the specified table to the largest value represented by the field’s data type. For example, an integer field would be filled with the number 32,767.
fill table table_name
• table_name – The name of the table whose table buffer fields will be filled.
The fill table statement is useful for setting ranges of information to be retrieved from a table.
The following table lists the storage types for which the fill operation applies, and the value to which the field will be set.
![[spacer]](1p.gif){kind=small}
|
Storage type |
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 |
|
DateTime |
12/31/9999 23:59:59 |
If the table specified is not open, the fill table statement will open it.