OraFAQ Forum: Forms » insert and update

Home » Developer & Programmer » Forms » insert and update (Forms oracle 10g)

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

insert and update [message #549854]

Wed, 04 April 2012 05:21

furqan
Messages: 115
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