des2k:Forms Generator,Prim key constraint and Error message
From: Lisa Tassoni <tassonl_at_ircm.umontreal.ca>
Date: Mon, 22 Jun 1998 16:58:02 GMT
Message-ID: <358E8CD4.B6D18DDE_at_ircm.umontreal.ca>
[Quoted] Hello everyone,
Date: Mon, 22 Jun 1998 16:58:02 GMT
Message-ID: <358E8CD4.B6D18DDE_at_ircm.umontreal.ca>
[Quoted] Hello everyone,
In Forms3.0, the CaseGenerator would create a pre-insert trigger like this at the block level (or field level), to validate the primary key of a base table:
DEFINE TRIGGER
NAME = PRE-INSERT TRIGGER_TYPE = V3 TEXT = <<<
/* CGUV$CHK_KEYS_ON_INSERT */
/* Call trigger(s) to check that the row to be inserted is
unique*/
/* according to the unique and primary keys that have been set
up*/
/* on this table*/
BEGIN CGUV$CHK_TINT_PK_G( :TI.TINT_NOM /* IN : Field value*/ ,:TI.GRP_NOM ); /* IN : Field value*/ message_popup('This intervention already exists', 'E',TRUE); EXCEPTION WHEN NO_DATA_FOUND THEN NULL; END;
Notice the error message: "This intervention already exists". It came from the Case Dictionary : it is the error message for violation of the primary Key constraint ( CGUV$CHK_TINT_PK_G).
Now with the Forms Generator of Designer 2000, an on-error trigger for
the block is created and the message displayed when the constraint is
violated
is (ORA-00001: Unique constraint violated)
How can I get the error message from the Repository?
Thanks in advance,
LT
Received on Mon Jun 22 1998 - 18:58:02 CEST