I want to add a sequence to the user_id field in user_info
table of my database. For which I have followed the below procedure.
table of my database. For which I have followed the below procedure.
- Create a db sequence named
“userid”
Create sequence userid start with 10000000001
- Open the Entity Attribute,
“user_id” in the Entity Object of the application - Select Type as Integer
and click on Value type “Expression”
radio button - Enter the below expression
in the value field
(new oracle.jbo.server.SequenceImpl(“USERID”,adf.object.getDBTransaction())).getSequenceNumber()
Where “USERID” is the sequence name
which is created already
which is created already
- Click on Ok
No Comments