Thanks everyone for your help. Yes, I do think it's in the interface. If I find out anything interesting I'll let you know..

----- Original Message -----
From: Helen Borrie
To: firebird-support@yahoogroups.com
Sent: Tuesday, November 01, 2005 10:58 PM
Subject: Re: [firebird-support] Re: Problem with integer


At 08:18 PM 1/11/2005 -0800, you wrote:
>No triggers and no events registered. I am calling this stored procedure
>from c# using the Firebird .net interface. The exact error message is
> "validation error for column STORAGEID, value \"*** null ***\"" string
>
>The code calling the stored procedure is
>
>FbCommand cmd = new FbCommand("ADDDIRECTORY", conn);
>
>cmd.CommandType = CommandType.StoredProcedure;
>
>cmd.Parameters.Add("@ID",ids[(int)FileTypes.Other]++);
>
>cmd.Parameters.Add("@PATH", path);
>
>cmd.Parameters.Add("@STORAGEID",0);
>
>
>
>Obviously Firebird knows 0 is not null on an integer.

Strangely enough, yes it does. :-) The point being made is that Firebird
does not (and has no means to) take an integer input value and convert it
to null. So it's your interface that is passing null. It looks as though
you need to ask this question on the firebird-net-provider list, to check
whether this behaviour is a response to some property setting in that
interface.

./heLen






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

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]