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
Messages: 62
Registered: May 2011
Location: pakistan
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


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
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
Messages: 21802
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
Messages: 13909
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: Does anyone know what happened with YoForms???
Next Topic: oracle listener error
Goto Forum:

Current Time: Sun Feb 25 23:38:46 CST 2024