Set Autonumber value

Set Autonumber value

  
Hi all,

Is it possible to set the autonumber value (actual sequence number) or shall I do it directly on the database?

Thank you in advance.

Best regards,
Filipe Feijão
Filipe Feijão wrote:
Hi all,

Is it possible to set the autonumber value (actual sequence number) or shall I do it directly on the database?

Thank you in advance.

Best regards,
Filipe Feijão
 
 
I have the same problem ... Trying to figure out a way of changing the numbers in a sequence to 3 numbers bellow because of a program error happened. Can i update the actual sequence number on the service studio? I tried to update the sequency number directly in the database but i can not acess it ... Do not remember the outsystems database password that i defined in the instalation ... How can i recover it? Anyone could help me with this problem? Thanks in advance for your kind help Ricardo Martins
i dont think that is possible at all, since it is part of the DB concept.

what you could or would need to do, is create a further ID field ie. DocId, BillId (whatever suits your application)
this way it is your decision how each record is numbered.

then i would create a further entity ie. NumberRanges
with Field, Increment or even Range etc (or just hardcode it)

2nd create a function, that will determine the next number,
according to the NumberRanges entity
and call it where you create or update the records

for the records you might already have in your entity
you should be able to create a temporary action
which will loop through all records and initialize the numbers