OraFAQ Forum: Forms » Update Form

Home » Developer & Programmer » Forms » Update Form (Developer 6I Database 10g Window XP)

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

Update Form [message #397653]

Mon, 13 April 2009 03:09

shahzaib_4vip@hotmail.com
Messages: 410
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

Report message to a moderator

Re: Update Form [message #397737 is a reply to message #397653]

Mon, 13 April 2009 12:02

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.

Report message to a moderator

Re: Update Form [message #397804 is a reply to message #397653]

Tue, 14 April 2009 00:23

shahzaib_4vip@hotmail.com
Messages: 410
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

Report message to a moderator

Re: Update Form [message #397855 is a reply to message #397804]

Tue, 14 April 2009 04:06

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.

Report message to a moderator

Previous Topic:	Hierachical trees in forms
Next Topic:	Looping in form using first record next record

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 20:32:10 CST 2025