OraFAQ Forum: Forms » tabular form not save multi record

Home » Developer & Programmer » Forms » tabular form not save multi record (form 6i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

tabular form not save multi record [message #657922]

Mon, 28 November 2016 02:04

mfahimaamirgmailcom
Messages: 62
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

Report message to a moderator

Re: tabular form not save multi record [message #657923 is a reply to message #657922]

Mon, 28 November 2016 02:18

Littlefoot
Messages: 21808
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.

Report message to a moderator

Re: tabular form not save multi record [message #657924 is a reply to message #657923]

Mon, 28 November 2016 03:03

cookiemonster
Messages: 13920
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.

Report message to a moderator

Previous Topic:	Does anyone know what happened with YoForms???
Next Topic:	oracle listener error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 02:09:03 CDT 2024