Subject | Creating trigger - SQL error |
---|---|
Author | Walter Neumann |
Post date | 2002-09-06T14:51:45Z |
Hi,
I am using Firebird 1.0, dialect 3, IBAccess. I was creating a trigger (form
Devweloppers Guide, p. 34) by IBAccess:
IBAccess - Table - Triggers - New Trigger
Name: BENUTZER_INSERT
Type: BeforeInsert
Position: 0
AS
BEGIN
if (new.Pkey = NULL) then
new.Pkey = gen_id(BENUTZER_GEN,1);
END
Error-Code:
Dynamic SQL Error
SQL error code=-104
Token unknown - line 3, char 18
NULL.
Why doesn't SQL know NULL?
Can anyone explain me whot's wrong?
Tank you.
Walter Neumann
I am using Firebird 1.0, dialect 3, IBAccess. I was creating a trigger (form
Devweloppers Guide, p. 34) by IBAccess:
IBAccess - Table - Triggers - New Trigger
Name: BENUTZER_INSERT
Type: BeforeInsert
Position: 0
AS
BEGIN
if (new.Pkey = NULL) then
new.Pkey = gen_id(BENUTZER_GEN,1);
END
Error-Code:
Dynamic SQL Error
SQL error code=-104
Token unknown - line 3, char 18
NULL.
Why doesn't SQL know NULL?
Can anyone explain me whot's wrong?
Tank you.
Walter Neumann