Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Deleting record under Forms

510 views
Skip to first unread message

Harry Yuen

unread,
Apr 29, 1998, 3:00:00 AM4/29/98
to

With Oracle Forms, is there a generic way to delete a selected record
in a multi-record block (by clicking into it) after an Exec-Query?

Harry Yuen

anthony simon

unread,
Apr 29, 1998, 3:00:00 AM4/29/98
to

have a button with this code

begin
do_key('DELETE_RECORD');
end;

anthony

Michael Krolewski

unread,
Apr 29, 1998, 3:00:00 AM4/29/98
to Harry Yuen

There are many commands. You probably want some PL/SQL associated with a
on-button-click command.

delete_record; deletes the current record in the form.

If the multi-record form is tabular, I generally please a button per
displayed record to make the delete very obvious.

Mike Krolewski

Dave Boswell

unread,
May 1, 1998, 3:00:00 AM5/1/98
to

Hi all,

On a similar note, when delete_record is used, and the delete fails due
to some database constraint, the record is still removed from the block,
just like clear_record. Is there some way to keep this from happening?
I am currently using a Prog Unit to do a DML delete, with exception
handling, and I clear the record only if the delete was successful.
This is fine for a few blocks on a form but requires a great string of
IFs when there are many blocks. Is there a better way?

Thanks,
Dave Boswell

0 new messages