The increment statement allows you to increment, or increase, a numeric value by a specified amount.
increment number {by numeric_expression}
• number – An integer, long, currency, variable currency, time or date field or variable that you want to increment.
• numeric_expression – A field or variable of the same control type as the number parameter, by which number is increased. If no numeric_expression is indicated, the default increment value is 1. The following default values are supported for each numeric control type:
Control type |
Default increment value |
---|---|
integer |
1 |
long |
1 |
currency |
1 currency unit |
variable currency |
1 currency unit |
time |
1 minute |
date |
1 day |