That chant, as it's been stated here a zillion times, is:
NULL is a state, *not* a value...
NULL is a state, *not* a value..

Since NULL is a state (*not* a value) you can't check for it using '='
*Nothing* will ever = NULL..

Use "IS NULL" or "IS NOT NULL"

Now repeat one more time:

NULL is a state, *not* a value... ;)

Best regards,
Fred Wilson
SE, Bell&Howell
fred.wilson@...


-----Original Message-----
From: Walter Neumann [mailto:walter@...]
Sent: Friday, September 06, 2002 7:52 AM
To: ib-support@yahoogroups.com
Subject: [ib-support] Creating trigger - SQL error


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


To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/