At 03:41 PM 11-01-01 +0000, you wrote:

>Hello again,
>
>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}

I'm just wondering why you need this parameter at all if you want to pass
Null every time.

Helen

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________