SERIAL Function
Function Type | Predefined function | |
Syntax | SERIAL( <serialName>, <initialValue> ) | |
Description | Returns the next serial value, incrementing the previous serial value by 1 for a given <serialName> each time this function is called. | |
Argument | Description | |
<serialName> | Unique string representing the serial name. | |
<initialValue> | Integer value equal to or greater than zero at which to begin serial number generation. | |
Returns | Integer | |
Example | In the following example, serial counter "actno" is initialized to zero. Upon execution, an incremental number is written in a field for every record, starting with the number 1. SERIAL("actno", 0) | |
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*