| query about the delete button [message #84911] |
Tue, 11 May 2004 10:04  |
Himanshu shekar shukla
Messages: 1
Registered: May 2004
|
Junior Member |
|
|
How we delete all the records which are associated through a foreign key with the pprimary key in the master table
i have created a button in form 6i and want to perform the same operaion on that button
Trigger Name: WHEN-BUTTON-PRESSED
Object Name: Personal.Delete
Usage: Delete the current record
declare
chk_button number;
begin
set_alert_property('confirm_alert',title,'Delete Record');
set_alert_property('confirm_alert',alert_message_text,'Current Master Entery Will Be Marked As Deleted. Do ou Want To Proceed….');
chk_button:=show_alert('confirm_alert');
commit;
end;
this is doing nothing.
windows 98se
Oracle 8i personal edition
orcale developer 2000 forms 6i
|
|
|
|
| Re: query about the delete button [message #84912 is a reply to message #84911] |
Tue, 11 May 2004 18:06  |
ram kumar
Messages: 113
Registered: August 2002
|
Senior Member |
|
|
declare
chk_button number;
begin
set_alert_property('confirm_alert',title,'Delete Record');
set_alert_property('confirm_alert',alert_message_text,'Current Master Entery Will Be Marked As Deleted. Do ou Want To Proceed….');
chk_button:=show_alert('confirm_alert');
if chk_button=alert_button1 then
delete_record;
end if;
commit;
end;
Ram
|
|
|
|
| Re: query about the delete button [message #85033 is a reply to message #84911] |
Mon, 24 May 2004 04:07 |
Anupam
Messages: 62
Registered: July 2001
|
Member |
|
|
replace the code
with this code
declare
chk_button number;
begin
set_alert_property('confirm_alert',title,'Delete Record');
set_alert_property('confirm_alert',alert_message_text,'Current Master Entery Will Be Marked As Deleted. Do ou Want To Proceed….');
chk_button:=show_alert('confirm_alert');
if chk_button=alert_button1 then
delete emp;
commit;
end if;
end;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
