| tabular form not save multi record [message #657922] |
Mon, 28 November 2016 02:04  |
 |
mfahimaamirgmailcom
Messages: 64
Registered: May 2011
Location: pakistan
|
Member |
|
|
dear friend
we use oracle 12/c with form 6i
i want to create tabular form
and create sequences with table for new auto record number
i use trigger PRE-Insert trigger see code
SELECT MEDICALDETAIL_SEQ.NEXTVAL
INTO :MEDICALDETAIL.MEDICALDETAILID
FROM DUAL;
but when i press save button
it save only first record and not save below record and give next value in only in first record
all below new record number null
and give me error FRM-40508 (FRM-40508)
please give me idea how save all record save time
please give me idea
regard
|
|
|
|
|
|
| Re: tabular form not save multi record [message #657924 is a reply to message #657923] |
Mon, 28 November 2016 03:03  |
cookiemonster
Messages: 13965
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
Pre-insert should fire for each record being saved. If it's only populating one record then presumably oracle thinks only the first record has any changes that need saving.
If you get FRM-40508 you should select display error from the help menu to see what it's complaining about. It shouldn't be lack of sequence value.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
