Home » Developer & Programmer » Forms » cannot delete record
cannot delete record [message #240240] Thu, 24 May 2007 07:50 Go to next message
sahadevanr
Messages: 9
Registered: May 2007
Location: pune
Junior Member

hi

i have created an application , where i have two different forms , each form refers to two different tables , these two tables have one field with a primary key , foreign key relationship .

now when i delete a record from the master table form , the record is not deleted & no message is shown in the status bar.
i want to catch the exception & display the message .
how do i catch the error & display the alert.

please help me out .
Re: cannot delete record [message #240252 is a reply to message #240240] Thu, 24 May 2007 08:14 Go to previous messageGo to next message
kamran.it
Messages: 265
Registered: September 2005
Location: Karachi
Senior Member
First you have to delete Detail record then you can delete master record.
Re: cannot delete record [message #240256 is a reply to message #240240] Thu, 24 May 2007 08:28 Go to previous messageGo to next message
mdawood
Messages: 3
Registered: May 2007
Location: Jordan
Junior Member
i think the solution is
check the properties for relation between of them
set the property for relation isolated
this property let you delete from master without delete from detail...

Moh Aldawood
Re: cannot delete record [message #240521 is a reply to message #240256] Fri, 25 May 2007 02:48 Go to previous message
sahadevanr
Messages: 9
Registered: May 2007
Location: pune
Junior Member

hi

i think the problem is solved ,

i caught the error , through ON_ERROR Trigger , and displayed the message in ALERT box "Delete the child record" .

thank you for ur response .


Previous Topic: List Item
Next Topic: FRM-10142
Goto Forum:
  


Current Time: Tue Dec 06 06:38:14 CST 2016

Total time taken to generate the page: 0.06296 seconds