This content has been marked as final. Show 6 replies
go to Column Attributes and under Tabular Form Attributes you define default type (to PL/SQL) and Default (your function for getting number) and it wil work .1 person found this helpful
I changed the type to PL/SQL. After that, do I need to create a pl/sql proc/function on the DB and then call it? I tried entering max(serial) + 1 which did not work.
there is many options, you can create one hiden item on the form and set value to them (then you must change default type to item value) or function on DB.
Thanks, Hidden item idea worked!
I would strongly suggest that you use a sequence. What you describe will not work in a multi-user environment.
I know this thread is an old one. But this is the closest question which I have in mind. I have a master detail form in which there is sequence for primary keys for both tables. However in the detail section I have a serial number which needs to be starting from 1 for every master record. While clicking on Add Row the next number should be calculated and shown in the screen.
If I am using a database procedure to return serial number, I doubt that for unsaved records the serial number will be same.
Please advice on how to achieve this.
I am using APEX in 11g Express Edition.