Increment by 10

aquinco · 2016-08-25

Hi guys

I have a table Transport Line and I want to increase value of field "Line No." by 10 when I go to a new row.
How can I do this without No. Series?
"Line No." is my primary key.
I tried this code but it doesn't work

Line No. - OnValidate()

IF "Line No." = ' ' THEN BEGIN
Lines.FINDLAST;
"Line No." := Lines."Line No." + 10;
END;

where Lines is rec variable of my table.
Thanks in advance

postsaurav · 2016-08-25

Have a look on the Sales Order subform Properties. That should help.
Delayed Insert, MultipleNewLines & AutoSplitKey should do the magic.

damkjer · 2016-08-25

Put the code in OnInsert trigger on the table.

postsaurav · 2016-08-25

Have a look on the Sales Order subform Properties. That should help.
Delayed Insert, MultipleNewLines & AutoSplitKey should do the magic.

Nikhipal · 2018-02-20

You are doing FindLast and then incrementing it with 10, It will not work 100% right. what if you creat 5 lines and delete a few in between. Better way ist find a free number and then multiply it with 10

Increment by 10

Best Answer

Answers

Categories