Lucas Franzen wrote:

>
> When you're deleting from the view, the record in the table will be
> updated *AND* deleted.
>
> If you change the view to a JOINED select then the trigger does what it
> should - just update the record.
>
> Is that as designed?
>

Yes and no. Originally, putting a trigger on a naturally updateable
view made the view non-updateable, so only the triggered operation
occurred. Later, Borland changed the design so naturally updateable
views continued to update naturally in addition to executing the
specified operation - as a table would. In V2, the operation was
changed back to the original design.

Regards,


Ann