Support Topics Documentation Slack YouTube Blog

Increment an Integer Field by One

How can I increment an integer field in a table by one without first accessing that field, picking what is already in there, adding +1 and updating the record? Atomic counters was suggested, but am not sure how to implement this with that.

Hello @Nkekere_Tommy_Minimann

You can find out how to use counters in the documentation: Atomic Counters API - Increment by 1, return current

Regarding updating the column value without receiving the previous value: we are now considering adding this functionality (BKNDLSS-20855).