Start Integer field from 1000 ???

(0) Share

Report

Posted on by Community Member

hi all,

i have a primary key field with type of integer and autoincrement = true, i want when i insert the record the primary key field start from 1000.

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

KTA 1,200 on at

Like (0)

Report

I guess that you've tried InitValue=1000 but that goes against the autoincrement

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

KTA picture

I guess that you've tried InitValue=1000 but that goes against the autoincrement

InitValue = 1000 not working

i want just like sales order line, Where Line No. start from 1000

Was this reply helpful? Yes No
KTA 1,200 on at

Like (0)

Report

You can try a different approach maybe it isn't the more efficent one but it should work. Instead using autoincrement you can use findlast and if there's one use previous+1 and if not =1000

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

@KTA

actually the main problem is assign 10000 to primary key and it will also be increment by 10000

Was this reply helpful? Yes No
bharathkarunakaran 475 on at

Like (0)

Report

Hi,

Please go the page where you have added that field and in the properties of that page give autosplitkey = "YES" and you will get you desired output.

I have answered upto my understanding.

Regards,

Bharath K

Please mark it as verified if found useful.

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,247 Super User 2025 Season 2 on at

Like (0)

Report

Open the table and manually insert a record with value 999. Then the code or process will automatically increment based on that value so the next value will be 1000....

Was this reply helpful? Yes No
KTA 1,200 on at

Like (0)

Report

[quote user="Tanveer Ahmad"]

@KTA

actually the main problem is assign 10000 to primary key and it will also be increment by 10000

[/quote]

In the first one because you couldn't find last record, i would be solved. Like this:

IF (rec.FINDLAST) THEN

Number:=rec.Number+1

ELSE

Number:=10000;

You can also use Suresh idea and make one entry of 999 and then autoincrement will work

Was this reply helpful? Yes No