The filled() function returns true if the specified field is set to its maximum value; otherwise, it returns false.
filled(field_name)
• field_name – The name of the field.
Boolean
The following table lists the storage types for which the filled() function can be used, and the value that each type will contain when it is considered 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 will be the storage size of the string minus 1. Each of the remaining bytes will be set to string equivalent of ASCII 255. |
|
Time |
23:59:59 |
|
DateTime |
12/31/9999 23:59:59 |
If the filled() function is used to check a field in a table that isn’t open, the table will be opened.