Re: Issue an Update on a Base Table
From: DanHW <danhw_at_aol.com>
Date: 26 Jan 2000 03:07:26 GMT
Message-ID: <20000125220726.01157.00000510_at_ng-bj1.aol.com>
Date: 26 Jan 2000 03:07:26 GMT
Message-ID: <20000125220726.01157.00000510_at_ng-bj1.aol.com>
>Hi !!
>
> My application is on Forms 6.0/Oracle8i server. I
>have a Database Block(no CTRL blocks) on a Base Table which
>has a Delete Flag field. Our Application requires that we
>update the delete flag field to 'Y' when there is a
>necessity to delete, instead of physically deleting the
>record from the databas
In the ON-DELETE trigger, put in the code to do the update.This will then replace the normal delete behavior with the code [the update] you have placed there.
Dan Hekimian-Williams Received on Wed Jan 26 2000 - 04:07:26 CET