I give up today with this SP.
I have changed to:
string val;
FbConnection fbsyspar = new
FbConnection(Properties.Settings.Default.AppConnStr);
FbCommand cmdGetSypParam = new FbCommand();
cmdGetSypParam.CommandText = "SELECT PVALUE FROM SYS_PARAMETERS WHERE
" +
"(PAR_CODE = @pcode) AND (SUBSYSTEM =
@psubsystem)";
cmdGetSypParam.CommandType = CommandType.Text;
cmdGetSypParam.Parameters.AddWithValue("@PCODE", cod);
cmdGetSypParam.Parameters.AddWithValue("@PSUBSYSTEM", ss);
cmdGetSypParam.Connection = fbsyspar;
fbsyspar.Open();
val = cmdGetSypParam.ExecuteScalar().ToString();
fbsyspar.Close();
It's working perfect...but stil wanna use my SP sometime!!!
Thanks Carlos, Jiri!
> -----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
