Other OutSystems sites...
OutSystems Website
About Agility Blog
OutSystems Network
Login
Signup
Forums
Academy
Forge
Ideas
Forums
›
Technology & Integration
›
Set Autonumber value
Set Autonumber value
Filipe Feijão
Rank: #344
Posted on 2012-05-24
thumbs_up_ico
0
thumbs_down_ico
0
reply
post_link_ico
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
Ricardo Martins
Rank: #2697
Posted on 2012-05-25
thumbs_up_ico
0
thumbs_down_ico
0
reply
post_link_ico
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
enigma
Rank: #93
Posted on 2012-05-25
thumbs_up_ico
0
thumbs_down_ico
0
reply
post_link_ico
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
Quick Reply
Notify me by email when someone answers to my post
attachment
Choose File
No file chosen
Submit
Login to reply
Something on your mind?
Login to Start a Discussion
Top Forums Posters
Gonçalo Martins
Ricardo Silva
Charles Colaço
João Rosado
André Vieira
Arnold Grippeling
Gerry
Robert Chanphakeo
JD
Mizé Williams
See leaderboard
Online Training
On-demand video lessons to help you learn at your own pace.
Learn More