Home » Developer & Programmer » Forms » delete_record
delete_record [message #85939] Fri, 13 August 2004 22:10 Go to next message
fanni
Messages: 96
Registered: March 2004
Member
hi

i have a master detail form. i execute query for a certain condition say employee no =9. all the detail block is poulated. now i have a delete button contining the code

delete_record

commit_form

 and i want to delete any detail record on pressing the DELETE button.

 

but it show NO CHANGES TO SAVE.

i am unable to resolve it

 

 

 
Re: delete_record [message #85956 is a reply to message #85939] Mon, 16 August 2004 22:00 Go to previous message
Himanshu
Messages: 457
Registered: December 2001
Senior Member
Hi,
First of all you need to set the Master-detail relationship prpoerty correctly.
Open the Relationship Property pallete and set the Propertry "DELETE RECORD BEHAVIOUR" to cascading.

Also remeber that if your Datablock s are Control blocks then nothig will be deleted and you need to write a specific query manually to delete the records.

HTH
Regards
Himanshu
Previous Topic: Using TEXT IO built-in package in Oracle Forms
Next Topic: Writing in Excel
Goto Forum:
  


Current Time: Wed Aug 07 15:28:09 CDT 2024