Home » Developer & Programmer » Forms » tabular form not save multi record (form 6i)
tabular form not save multi record [message #657922] Mon, 28 November 2016 02:04 Go to next message
mfahimaamirgmailcom
Messages: 50
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 #657923 is a reply to message #657922] Mon, 28 November 2016 02:18 Go to previous messageGo to next message
Littlefoot
Messages: 21229
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You'd have to do that in a loop, through all records.

Or, even simpler, populate item in WHEN-CREATE-RECORD trigger (using the same code).

Or, move that code into a database trigger.

Re: tabular form not save multi record [message #657924 is a reply to message #657923] Mon, 28 November 2016 03:03 Go to previous message
cookiemonster
Messages: 12927
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.
Previous Topic: Run forms wthout JRE
Next Topic: oracle listener error
Goto Forum:
  


Current Time: Sun Nov 19 23:48:18 CST 2017

Total time taken to generate the page: 0.01099 seconds