The fill statement sets a field to the largest value represented by the field’s data type, regardless of any keyable length or format applied to the field. For example, an integer field would be filled with the number 32,767.
fill field_name {, field_name, field_name, ...}
• field_name – The name of the field to be filled.
The fill statement is useful for setting ranges of information to be displayed from a table.
You can fill multiple fields using one fill statement, by listing each field name separated by a comma.
The following table lists the storage types for which the fill statement can be used, and the value with which the field will be filled:
![[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 |
Fields with date or time control types will be displayed using the format specified for their data types. For example, a filled time field might be displayed as 12:59:59 PM.
If the table containing the field to be filled is not open, the fill statement will open the table.