How to delete a record from detail table [message #282799] |
Fri, 23 November 2007 08:37  |
vishubms
Messages: 10 Registered: October 2006 Location: Bangalore
|
Junior Member |
|
|
Dear Techies,
I am using forms 6i & Oracle 8i. Am getting an error while trying to delete a record from detail block. I can delete all the records from detail table using delete_record. But i dont want to delete all the record but only the record where the cursor is placing. I also tried to use where clause in delete command but its throwing an error orc-01422 & foms-40375.
Plese let me know the solution.
Thanks & Regards,
Urs Vishwanath
|
|
|
Re: How to delete a record from detail table [message #282807 is a reply to message #282799] |
Fri, 23 November 2007 11:35  |
 |
Littlefoot
Messages: 21823 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
It seems that you are doing it completely wrong.
Current record is deleted by pressing the "delete record" button in Form's menu bar (or by selecting 'Record' menu and 'Delete' within it).
Do not code built-in Forms' functionality; you'll only get a headache.
The error you got was[quote=Oracle]ORA-01422: exact fetch returns more than requested number of rows
Cause: The number specified in exact fetch is less than the rows returned.
Action: Rewrite the query or change number of rows requested[/code]
It was caused by writing your own code and it didn't work.
However, if there's a business requirement which says that you MUST delete a record by writing your own trigger, post it here so that we could see it. We are not mind readers and don't know what you've really done. You could even create a sample form based on Scott's schema and someone will probably take a look at it.
|
|
|