Home » Developer & Programmer » Forms » FRM-40743
FRM-40743 [message #312914] Thu, 10 April 2008 01:58 Go to next message
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
Re: FRM-40743 [message #312917 is a reply to message #312914] Thu, 10 April 2008 02:04 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Re: FRM-40743 [message #313193 is a reply to message #312917] Fri, 11 April 2008 01:04 Go to previous messageGo to next message
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


Re: FRM-40743 [message #313194 is a reply to message #313193] Fri, 11 April 2008 01:06 Go to previous messageGo to next message
sinida1984
Messages: 83
Registered: September 2007
Location: India
Member
hi

in user_updatable_columns all the columns other than certificate_name is there
Re: FRM-40743 [message #313581 is a reply to message #313193] Sun, 13 April 2008 19:11 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Previous Topic: Re: Serial Ports
Next Topic: FRM-40108-no such form
Goto Forum:
  


Current Time: Sat Dec 10 18:55:19 CST 2016

Total time taken to generate the page: 0.09424 seconds