| cannot delete record [message #240240] |
Thu, 24 May 2007 07:50  |
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 #240256 is a reply to message #240240] |
Thu, 24 May 2007 08:28  |
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 |
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 .
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
