OraFAQ Forum: Forms » FRM-40743

Home » Developer & Programmer » Forms » FRM-40743

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

FRM-40743 [message #312914]

Thu, 10 April 2008 01:58

sinida1984
Messages: 83
Registered: September 2007
Location: India

Member

Hi all
I have a database datablock with two tables joined. And the table which is main does not have a primary key. I am using this type for the first time. And i need to do all the DML operations on data. But when i update any date error 'FRM 40743- This operation with no base table requires the ON-LOCK trigger' is coming. How can i do editing and all? Is it possible for a database block with more than one table?

Thanks and regards
Sinida

Report message to a moderator

Re: FRM-40743 [message #312917 is a reply to message #312914]

Thu, 10 April 2008 02:04

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

I suggest defining your table and their relationship via a 'view'. You can then use 'user_updatable_columns' to see which columns are available for update.

For further information on this subject, search this forum or site for 'user_updatable_columns'.

David

Report message to a moderator

Re: FRM-40743 [message #313193 is a reply to message #312917]

Fri, 11 April 2008 01:04

sinida1984
Messages: 83
Registered: September 2007
Location: India

Member

Hi
Thanks for your reply. I tried using a view.

create or replace view co_trf_cert_view as select a.*,b.certificate_name from co_trf_certificate a,
co_certificate b where b.certificate_code = a.certificate_code

But that is not allowing me to save the updated records through a form. In SQL the update, delete statements are working. When i press saveOrracle error..unable to update record.'ORA-01776: cannot modify more than one base table through a join view' from Shift + F1. So is this possible to update ? When i delete the columns which i took from master it s updated.
But that was not my need. Pls give me a solution

Thanks and regards
Sinida

Report message to a moderator

Re: FRM-40743 [message #313194 is a reply to message #313193]

Fri, 11 April 2008 01:06

sinida1984
Messages: 83
Registered: September 2007
Location: India

Member

hi

in user_updatable_columns all the columns other than certificate_name is there

Report message to a moderator

Re: FRM-40743 [message #313581 is a reply to message #313193]

Sun, 13 April 2008 19:11

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Look at all the fields of 'user_updatable_columns'. The column 'updatable' tells you whether you can update the information associated with that column.

I believe that you are trying to update the value in the 'master' table 'co_certificate'. I don't think that this is appropriate.

David

Report message to a moderator

Previous Topic:	Re: Serial Ports
Next Topic:	FRM-40108-no such form

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Mar 11 12:56:42 CDT 2025