Re: Forms: reusable pre-insert trigger
From: Lang Richard <richard_at_dse.it>
Date: Mon, 28 Jun 1999 16:34:02 +0200
Message-ID: <7l804k$d6m$1_at_fe2.cs.interbusiness.it>
Date: Mon, 28 Jun 1999 16:34:02 +0200
Message-ID: <7l804k$d6m$1_at_fe2.cs.interbusiness.it>
Try a Forms-Level-Trigger with:
COPY (USER, :system.trigger_block||'.audit_username'); COPY (SYSDATE, :system.trigger_block||'.audit_date');
USER is a SQL-Function that returns the current USERNAME :system.trigger_block contains the name of the block that "fires" the trigger... Received on Mon Jun 28 1999 - 16:34:02 CEST