OraFAQ Forum: Forms » Comit in forms

Home » Developer & Programmer » Forms » Comit in forms (Forms 10g)

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

Comit in forms [message #562162]

Mon, 30 July 2012 01:41

dev_777
Messages: 32
Registered: June 2010

Member

Hi

I have a form with two data blocks. The first multi row block displayed is the master block (parts_master) followed by the multi row detail block below (parts_lines).

I have a check box on the parts_master block. When I check the box, all related lines are displayed in the detailed block below.

I then change values in one of the fields from the detail block. I don't want to commit at this stage. I then click the check box on the master block to select another parts_master record. Immediately, forms throws up a message asking me whether I want to comit my changes. I know that this is forms behaviour.

How do I bypass this message wanting me to comit? I want to do a single comit at the end.

Report message to a moderator

Re: Comit in forms [message #562163 is a reply to message #562162]

Mon, 30 July 2012 01:59

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

Senior Member
Account Moderator

I don't think that you can do that. As soon as master record changes, detail block gets changed as well and - if you don't commit - everything you did is lost.

Report message to a moderator

Re: Comit in forms [message #562202 is a reply to message #562163]

Mon, 30 July 2012 06:47

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Can't you save the changed values (with a key) to a global temp table and set the record status to query when you change the parent? On commit you can process the temporary table.

Just a long shot. I don't have access to forms builder right now ...

MHE

Report message to a moderator