Logic looks fine.
We need more details to figure this one out.
What is the callstack of the exception?

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

----- Original Message -----
From: <hundri_106@...>
To: <IBObjects@yahoogroups.com>
Sent: Thursday, October 11, 2001 6:56 PM
Subject: [IBO] EConvert error when passing to storedprocs?


> Hi,
>
> I am trying to run this stored procedure (simplified):
> UPDATE abc SET abc.z=:IntParam
>
> (z and IntParam are declared as integers) and all is fine. But then
> when I try in delphi to pass it a parameter like this:
>
> storproc.parambyname('intParam').asInteger:=-1;
>
> and then execute it I get an EConvert error because "-" is not a
> valid integer !
>
> Where did my logic go wrong ?? :-(