Variable in a message [message #80197] |
Thu, 22 August 2002 01:54 |
Wilbert
Messages: 2 Registered: August 2002
|
Junior Member |
|
|
Hi I have his code:
[[code]]
DECLARE
VDeelnemerid INTEGER;
BEGIN
Select max(deelnemerid) INTO VDeelnemerid from deelnemer;
VDeelnemerid := VDeelnemerid + 1;
IF :deelnemerid NOT LIKE VDeelnemerid THEN
MESSAGE('Het volgende deelnemerid moet als nummer, &VDeelnemerid, hebben');
RAISE FORM_TRIGGER_FAILURE;
END if;
END;
Now the idea is that the variable vdeelnemerid
(a number) wil be visible in the message.
But it doesnt work like this.
Anyone have any Iea?
Thanx in advance
Wilbert Corts
|
|
|
|
|
|