devxlogo

Adding Leading Zeroes

Adding Leading Zeroes

Question:
A control record value for next_order_num will contain the value “00009998” when you first get the control record file. Each time you write the next_order_num field back into the control record, I want the leading zeroes to be in place. For example, when you add 1 to “00009998”, it should write “00009999” into the control record as the next_order_num value.Please help me solve this problem.

Answer:
Before you add to the number, take the Val() of it. Add the appropriate value, and then use the Format$ function to put the leading zeroes back on. That’s the cleanest way to do it.

devx-admin

Share the Post: