Home » Developer & Programmer » Forms » How to delete a record from detail table (Forms 6i, Oracle 8i)
How to delete a record from detail table [message #282799] Fri, 23 November 2007 08:37 Go to next message
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 Go to previous message
Messages: 20847
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.
Previous Topic: Form in browser probelm !
Goto Forum:

Current Time: Mon Oct 24 13:45:38 CDT 2016

Total time taken to generate the page: 0.26563 seconds