How to set Sr no automatic.

(0) Share

Report

Posted on by Nilam Bhor

153

Hii guys,

For example: Here ,My column is sr.no,and this sr.no is a primary key .I write this logic,but I am getting output in sr no start with 0.

I want sr .no starts with 1.

Is there is any way to do this.

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Nitin Verma 21,698 Moderator on at

Like (0)

Report

RE: How to set Sr no automatic.

Hi,

You can set field property as per below,

AutoIncrement=true;

learn.microsoft.com/.../devenv-autoincrement-property

Was this reply helpful? Yes No
Suggested answer

Nilam Bhor 153 on at

Like (0)

Report

RE: How to set Sr no automatic.

No. Actually I want write a logic for sr no gets automatic.

We don't want autoincrement property.

My result is come, but it starts with 0.

I want number starts with 1.

Was this reply helpful? Yes No

Suggested answer

Nitin Verma

21,698 Moderator on at

Like (0)

Report

RE: How to set Sr no automatic.

Try below code

trigger OnInsert()
var
YourTable: Record YourTable;
begin
"Entry No." := 1;
YourTable.Reset();
YourTable.SetRange("Entry No.");
if YourTable.FindLast() then
"Entry No." := YourTable."Entry No." + 1;
end;;