|Subject||Re: Problem with integer|
> * Table: DIRECTORIES, Owner: IBEASY */Any insert triggers on directories?
> CREATE TABLE "DIRECTORIES"
> "ID" INTEGER NOT NULL,
> "PATH" CHAR(255) NOT NULL,
> "STORAGEID" INTEGER NOT NULL,
> CONSTRAINT "RDB$PRIMARY8" PRIMARY KEY ("ID")
> INSERT INTO directories(
> ) VALUES (
They will fire at this point and may be doing something if so?
> SUSPEND;Anything registered for this event that might be attempting to run a
> /* Notify listeners of insert */
> POST_EVENT 'insert_sptable1_ins';
> ENDI would disagree with that comment, IMO path should probably be a
> id,path and storageid are correctly defined.
varchar, path will pad with spaces. But that is not your issue here.
I can assure you that Firebird understands the difference between
NULL and 0 in an integer field. The begin is a snippet of I assume a
stored procedure. What program is calling this stored procedure?
Use isql to run it. If it runs fine, then you know it is something in
the interface layer of the program you are using. If there is still a
problem, then look for the triggers.
If you still have problems, you need to place the exact error
message. It should tell you which field is null. But my money is on
an insert trigger.