| Subject | EConvert error when passing to storedprocs? |
|---|---|
| Author | hundri_106@hotmail.com |
| Post date | 2001-10-12T01:56:31Z |
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 ?? :-(
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 ?? :-(