Home » Developer & Programmer » Forms » Update Form (Developer 6I Database 10g Window XP)
Update Form [message #397653] Mon, 13 April 2009 03:09 Go to next message
shahzaib_4vip@hotmail.com
Messages: 376
Registered: December 2008
Location: karachi
Senior Member


I create a table item which relate 2 column

Item_no (Primary key)
item_name

and i create another table sale

which relate

saledate
item_no_sale (Foreign key)
item_name_sale
qty


now in form when i insert record in table item i want to update these data in sale table without exit the form

there is any way to update my sale table with Push button ?


Thanks


Shahzaib Ismail
Re: Update Form [message #397737 is a reply to message #397653] Mon, 13 April 2009 12:02 Go to previous messageGo to next message
jagadeeshg
Messages: 14
Registered: December 2007
Location: BLR
Junior Member

write a database trigger on item table on insert for each row condition. This will solve the problem.

Another option is write an extra piece of code post-insert
trigger in form level and commit it.
Re: Update Form [message #397804 is a reply to message #397653] Tue, 14 April 2009 00:23 Go to previous messageGo to next message
shahzaib_4vip@hotmail.com
Messages: 376
Registered: December 2008
Location: karachi
Senior Member
Quote:
write a database trigger on item table on insert for each row



which kind of trigger ? please explain


Thanks


Shahzaib
Re: Update Form [message #397855 is a reply to message #397804] Tue, 14 April 2009 04:06 Go to previous message
danish_fsd@yahoo.com
Messages: 38
Registered: February 2008
Location: Pakistan
Member
Hi,

You can Write insert statement on "Before Insert" or "After Insert" FOR EACH ROW Trigger on Item Table which inserts same data at Sale Table.

You can find these triggers in Developer Object Navigator under Database Object node.

You must study "For Each Row" Triggers first.

Hope it is your required explanation.

Regards

Danish.
Previous Topic: Hierachical trees in forms
Next Topic: Looping in form using first record next record
Goto Forum:
  


Current Time: Sun Dec 04 04:50:51 CST 2016

Total time taken to generate the page: 0.08092 seconds