You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to assign a number using sql to a DFF?

Accepted answer


Need to assign a 5 digit number using sql to supplier DFF

Content (required):

we have a DFF called address_indicator where we need to populate it with 5-digit number, and everytime a new entry is created, it increases by 1. So for 1st address when created, it should automatically be 10000, then when second address is created it should automatically be 100001 and so on.

we have selected default type as SQL under DFF, but not sure how to write that sql.

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!