Home » Developer & Programmer » Forms » How Two Records in Oracle Forms (Oracle 10g)
How Two Records in Oracle Forms [message #665650] Thu, 14 September 2017 01:06 Go to next message
Fiaz26
Messages: 1
Registered: September 2017
Location: Punjab Pakistan
Junior Member
Hi

I am Creating And Inventory Management App in i have block masterdetail named orderdetail. with column pcode,productname,unitprice,qty,soh etc
after entering the pcode when i move to qty if i enter qty value like for example 12 the result should come like
pcode productname unitprice qty
1     xyz         12.8        12
1     xyz         0            1

means i want multi insert row in to block


[LF applied [code] tags]

[Updated on: Thu, 14 September 2017 01:23] by Moderator

Report message to a moderator

Re: How Two Records in Oracle Forms [message #665651 is a reply to message #665650] Thu, 14 September 2017 01:26 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I suppose that you should use the ON-INSERT trigger.
Re: How Two Records in Oracle Forms [message #665655 is a reply to message #665651] Thu, 14 September 2017 03:28 Go to previous message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
Do want to automatically insert rows into the same block?
How many?
Previous Topic: Forms 6i Installation Error
Next Topic: FRM-40102 Record must be entered or deleted first
Goto Forum:
  


Current Time: Thu Mar 28 17:51:33 CDT 2024