There must be something in your database or stored procedure that is setting
a column to null that isn't allowed. Look at your domain and column settings
for a NOT NULL constraint.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Dale Tabbert" <dale@...>
To: <IBObjects@egroups.com>
Sent: Thursday, January 11, 2001 8:41 AM
Subject: [IBO] Re: Null in Stored Procedure parameter.


> Hello again,
>
> --- In IBObjects@egroups.com, Lucas Franzen <luc@r...> wrote:
> > When calling the procedure this should work:
> >
> > procedure DoExceSP;
> > begin
> > with mySP do
> > begin
> > Prepare;
> > if noID
> > then ParamByName ( 'ID' ).Clear
> > else ParamByName ( 'ID' ).AsInteger := myID;
> > ParamByName('VAL').AsString := mykeyValue;
> > ExecProc;
> > Unprepare;
> > end;
> > end;
>
> I still get ISC ERROR MESSAGE:
> validation error for column KEYWORD_ID, value ''***null***''.
> Process stopped. Use Step or Run to continue
>
> What am I missing??? Here is the code.
>
> with spAddObjKWValue do begin
> Prepare;
> parambyname('Object_ID').AsInteger := object_id;
> parambyname('Keyword_id').clear;
> parambyname('Keyword_Name').AsString := 'Some Name';
> parambyname('Keyword_Value').AsString := 'Some Value';
> ExecProc;
> Unprepare;
> end;{with spAddObjKWValue}
>
> Dale
>
>
>
>