Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem - Delete_Record

434723Dec 14 2004 — edited Dec 15 2004

HI all,

I have some multi-record blocks. I want to delete specific records that don't fullfill certain condition. Like their is a option "Remove" under "Record" in Default Forms Menu of Oracle Forms 6i.

i want to remove (delete) record just like that) and also i want to implement this check on "Block Level"

I have used many kinds of triggers: PRE-INSERT, PRE-UPDATE, WHEN-VALIDATE-RECORD, KEY-COMMIT etc. and in them i wrote:

if <condition> then

delete_record;

end if;

but this is not working. it doesn't removes the record.

Urgent help needed ...

regards,

yasir

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 12 2005

Added on Dec 14 2004

#forms, #moved-from-devops

5 comments

3,601 views