Devide Existing entry Nos by 10

mustafaAlsoufi · 2021-06-16

Hi everyone,

I'm trying to divide all the EXISTING Entry Nos by 10 as it reached the maximum limit(The range for 32bits is 2,147,483,648).

So by dividing all the existing Entry No. and by changing the incrementation from 10,000 to 1000, I would extend how many more lines I can add, which is about 10x.

My question is how can I divide the Existing Entry Nos and should I add the code in the table or somewhere else?

Thank you in advance.

mustafaAlsoufi · 2021-06-16

Also, please note that Entry No. is the only key in the table and I want to keep it that way.

Me_Ontour · 2021-06-21

Hi,

there are a few things to consider
Is there a tabelrelatiuon from another Table?
Can all Entries divieded by 10 or are there entries like
10502

How long did it take to reach the full range of an integer (Is 10 enough or should it be an increment by 1)

Table.Reset;
Table.find('-');
repeat

Table2 := Table;
Table2.Rename(Table."Entry No." DIV 10);

until Table.next = 0;

If You can use SQL you can try someting like

Update Table
Set "Entry No." = "ENTRY NO:" / 10

OR

if you would like to renumber from the beginning

DECLARE @NewEntryNo int = 1

Update Table
Set "Entry No_" = @NewEntryNo
,@NewEntryNo += 1

Cheers Chris

Howdy, Stranger!

Quick Links

Categories

Devide Existing entry Nos by 10

Answers