| Delete record [message #84958] |
Sat, 15 May 2004 01:02  |
Art
Messages: 6
Registered: July 2002
|
Junior Member |
|
|
I want to delete a record using a button.
The trigger code i defined behind the button is
-
if show_alert('del_ged')=alert_button1 then
delete_record;
commit;
end if;
end;
-
When i execute the form and i push on the delete button i get following error
"FRM-40510:Oracle error:unable to DELETE record"
I've set the delete record property of the relations of the master block to Isolated
|
|
|
|
| Re: Delete record [message #84959 is a reply to message #84958] |
Sat, 15 May 2004 01:08  |
Himanshu
Messages: 457
Registered: December 2001
|
Senior Member |
|
|
Hi,
First of tell me, are you trying to delete Master record or the Detail record.
If you are doing this in Master block & the Property is Isolated then also if you have Integrity constraints defined in the Database, Oracle will not allow you to delete the record.
Also check your Block property and see if Delete allowed property is set to YES.
Regards
Himanshu
|
|
|
|
| Re: Delete record [message #84960 is a reply to message #84959] |
Sat, 15 May 2004 01:16 |
Art
Messages: 6
Registered: July 2002
|
Junior Member |
|
|
I want to delete the Master record, i have constraints defined in the database.
The Delete Allow property is set to YES.
How can i delete anyway this record ?
to set the delete_record property to cascading ?
Greetz
|
|
|
|
| Re: Delete record [message #84961 is a reply to message #84960] |
Sat, 15 May 2004 01:33 |
Himanshu
Messages: 457
Registered: December 2001
|
Senior Member |
|
|
Yes Art,
If you want to Keep the Property as "ISOLATED" then you will have to drop the Integrity constraint in DB else you need to chnage the Property to "CASCADE".
Regards
Himanshu
|
|
|
|
| Re: Delete record [message #84963 is a reply to message #84961] |
Sat, 15 May 2004 01:46 |
Himanshu
Messages: 457
Registered: December 2001
|
Senior Member |
|
|
Art,
Just to clarify my Previos reponse that you need to change the Property "DELETE RECORD BEHAVIOUR" in the Mater detail relationship Property pallete of your Form to "CASCADING".
Regards
Himanshu
|
|
|
|
| Re: Delete record [message #84964 is a reply to message #84963] |
Sat, 15 May 2004 02:41 |
Art
Messages: 6
Registered: July 2002
|
Junior Member |
|
|
Still the same error message
FRM-40510:oracle error:unable to delete record.
I tried it with a form with one block en no relations for deleting the record.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
