Home » Developer & Programmer » Forms » insert and update (Forms oracle 10g)
insert and update [message #549854] Wed, 04 April 2012 05:21 Go to next message
furqan
Messages: 112
Registered: January 2012
Location: Hyderabad
Senior Member
greeting ..hi

i have (ship_master-ship_detail) receive material form.when open the form all
the master items appears except receiver name and receiver id.
when i select the receiver name and id thru lov...all the items (with send information)in
ship_detail also comes up expect rec_qty.i put the rec_qty and save from.

now i want to insert(ship_detail) information in another table apart from ship_detail table.
if that particular matrial already exist in table it shud only update receive quantity column with +.
if iam receiving the material first time then it shud just insert a record with ship_detail items.

so where shud i write the insert and update.

[Updated on: Wed, 04 April 2012 05:33]

Report message to a moderator

Re: insert and update [message #549877 is a reply to message #549854] Wed, 04 April 2012 06:21 Go to previous message
Littlefoot
Messages: 19601
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
One option might be a BEFORE UPDATE database trigger on SHIP_DETAIL table.

[Updated on: Wed, 04 April 2012 06:21]

Report message to a moderator

Previous Topic: A button has to be disabled in Query mode(F11)
Next Topic: Oracle forms builder 10g crashes when trying to go to Layout Editor
Goto Forum:
  


Current Time: Tue Sep 16 03:20:45 CDT 2014

Total time taken to generate the page: 0.17225 seconds