Subject Re: EConvert error when passing to storedprocs?
Author hundri_106@hotmail.com
Hmm... problem seems to have cleared itself one reboot and one
database sweep later... windows must have been trashed somewhere
along the line :-(

Thanks anyway!

--- In IBObjects@y..., "Jason Wharton" <jwharton@i...> wrote:
> 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@h...>
> To: <IBObjects@y...>
> 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 ?? :-(