Home » Developer & Programmer » Forms » Updation of Record in Join Condition Block (oracle 10g Forms [32 Bit] Version 10.1.2.0.2 (Production), window Xp)
Updation of Record in Join Condition Block [message #557477] Wed, 13 June 2012 01:54 Go to next message
myclassic
Messages: 136
Registered: December 2006
Location: Pakistan
Senior Member
i want to update record that is fetched based on join condition on form

1. made a block manually :::: EMPSAL
2. Query DATA SOURCE NAME :::: EMP a, Sal b
3. Where Clause :::: a.empid = b.empid
4. DML DATA Target Type :::: Table
5. DML DATA Target Name :::: EMP a, Sal b
6. All Columns are marked a.empid, a.empname, b.sal, b.date etc

It does not allow me to update record.
how is it possible??
Regards.

Report message to a moderator

Re: Updation of Record in Join Condition Block [message #557491 is a reply to message #557477] Wed, 13 June 2012 06:26 Go to previous message
sandeepgujje
Messages: 28
Registered: January 2012
Location: India
Junior Member
Better if you can post the error you got while updating

(If possible make use of the ON-UPDATE trigger to update the tables..)

Report message to a moderator

Previous Topic: Get User IP Address
Next Topic: move cursor [merged 2 by jd]
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jul 05 22:16:55 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.