Hi Carlos
I try putting @ before params and I get :
"Additional information: arithmetic exception, numeric overflow, or string
truncation"

I tested in dataset->Preview data, works ok, as procedure or sql.
It's not working from code!


> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf
> Of Carlos Guzmán Álvarez
> Sent: Thursday, January 11, 2007 9:13 PM
> To: For users and developers of the Firebird .NET providers
> Subject: Re: [Firebird-net-provider] Error on geting value from stored
> procedure
> 
> Hello:
> >
> >             cmdGetSypParam.Parameters.AddWithValue("PCODE", cod);
> >
> >             cmdGetSypParam.Parameters.AddWithValue("PSUBSYSTEM", ss);
> >
> 
> Try as:
> 
>             cmdGetSypParam.Parameters.AddWithValue("@PCODE", cod);
> 
>             cmdGetSypParam.Parameters.AddWithValue("@PSUBSYSTEM", ss);
> 
> 
> 
> --
> Carlos Guzmán Álvarez
> Vigo-Spain
> 
> http://carlosga.wordpress.com
> 
> -----------------------------------------------------------------------
> --
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share
> your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVD
> EV
> _______________________________________________
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Reply via email to