OraFAQ Forum: Forms » COMMIT WITH CONDITION

Home » Developer & Programmer » Forms » COMMIT WITH CONDITION (oracle 10g)

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

COMMIT WITH CONDITION [message #574332]

Wed, 09 January 2013 01:49

furqan
Messages: 115
Registered: January 2012
Location: Hyderabad

Senior Member

hello sir,

after committing form i want to clear few item and retain few item
and make the form ready for next record to be inserted along with retained item.

Thank you very much in advanced

regards

Report message to a moderator

Re: COMMIT WITH CONDITION [message #574334 is a reply to message #574332]

Wed, 09 January 2013 02:15

furqan
Messages: 115
Registered: January 2012
Location: Hyderabad

Senior Member

now able to clear some item but when iam entering new data in
those items its updating the existing record..not entering new record...

help needed...thanks

Report message to a moderator

Re: COMMIT WITH CONDITION [message #574336 is a reply to message #574334]

Wed, 09 January 2013 02:38

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

Senior Member
Account Moderator

See whether something like this helps:

-- open a new record
next_record;

-- duplicate values from the previous record to a newly created one
duplicate_record;   

-- clear some items
:block.item_1 := null;
:block.item_4 := null;
:block.item_7 := null;

Report message to a moderator

Re: COMMIT WITH CONDITION [message #574341 is a reply to message #574336]

Wed, 09 January 2013 03:58

furqan
Messages: 115
Registered: January 2012
Location: Hyderabad

Senior Member

thank you for your reply...
in my form i have purchase order number,date and serial no.
when i enter first record..serial number will be 1..when commit
serial number changes to 2 and i want purchase order number and date
to remain the same for second record and rest other items shud get clear.

--on commit button
commit_form;
next_record;
:pr_inp_upt.PROCESS_TYPE:=NULL;
:pr_inp_upt.UNIT:=NULL;

when try to enter second record with new process type and unit...its updating
the first record and not entering second record with new items(process_type,unit).

Thanks...

[Updated on: Wed, 09 January 2013 04:00]

Report message to a moderator

Re: COMMIT WITH CONDITION [message #574343 is a reply to message #574341]

Wed, 09 January 2013 04:13

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

Senior Member
Account Moderator

According to what you wrote here, that shouldn't happen. NEXT_RECORD is ... well, next record, not the same record.

Run the form in debug mode and trace its execution in order to find out what is going on.

Report message to a moderator

Previous Topic:	error in signature
Next Topic:	List Item

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 16:30:44 CDT 2024