Theres not much to it but here it is...

* Table: DIRECTORIES, Owner: IBEASY */

CREATE TABLE "DIRECTORIES"
(
"ID" INTEGER NOT NULL,
"PATH" CHAR(255) NOT NULL,
"STORAGEID" INTEGER NOT NULL,
CONSTRAINT "RDB$PRIMARY8" PRIMARY KEY ("ID")
);

BEGIN
INSERT INTO directories(
id,path,storageid
) VALUES (
:id,:path,:storageid
);
SUSPEND;

/* Notify listeners of insert */
POST_EVENT 'insert_sptable1_ins';
END

id,path and storageid are correctly defined.

----- Original Message -----
From: Alexandre Benson Smith
To: firebird-support@yahoogroups.com
Sent: Tuesday, November 01, 2005 3:33 PM
Subject: Re: [firebird-support] Problem with integer


ShofB wrote:

>I have a stored procedure writing a record which contains several integers. If I try and write 0 to one of the ints I get an error saying that is a null value. How can that be? Anyone every had this happen and what do I do about it?
>________________________________________________________________
>Shof Beavers
>
>
>
Shof,

Could you show us the code ?

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br



++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++




SPONSORED LINKS Technical support Computer technical support Compaq computer technical support
Compaq technical support Microsoft technical support Dell computer technical support


------------------------------------------------------------------------------
YAHOO! GROUPS LINKS

a.. Visit your group "firebird-support" on the web.

b.. To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


------------------------------------------------------------------------------




------------------------------------------------------------------------------


No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.362 / Virus Database: 267.12.7/153 - Release Date: 11/1/2005

----------

No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.362 / Virus Database: 267.12.7/153 - Release Date: 11/1/2005


[Non-text portions of this message have been removed]