OraFAQ Forum: Forms » How Two Records in Oracle Forms

Home » Developer & Programmer » Forms » How Two Records in Oracle Forms (Oracle 10g)

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

How Two Records in Oracle Forms [message #665650]

Thu, 14 September 2017 01:06

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

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I suppose that you should use the ON-INSERT trigger.

Report message to a moderator

Re: How Two Records in Oracle Forms [message #665655 is a reply to message #665651]

Thu, 14 September 2017 03:28

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

Do want to automatically insert rows into the same block?
How many?

Report message to a moderator

Previous Topic:	Forms 6i Installation Error
Next Topic:	FRM-40102 Record must be entered or deleted first

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 00:38:46 CST 2025