Hi
FB2 SS, Firebird .Net provider 2.1.0, VS2005 c#.
I have in database one procedure like this:
CREATE PROCEDURE SYS_GET_PARAM (
psubsystem char(3),
pcode varchar(30) character set iso8859_2)
returns (
pval varchar(30) character set iso8859_2)
as
begin
select pvalue from sys
Hello:
>
> cmdGetSypParam.Parameters.AddWithValue("PCODE", cod);
>
> cmdGetSypParam.Parameters.AddWithValue("PSUBSYSTEM", ss);
>
Try as:
cmdGetSypParam.Parameters.AddWithValue("@PCODE", cod);
cmdGetSypParam.Parameters.AddWithValue("@PSUBSYSTEM", ss
Mercea Paul wrote:
> FbCommand cmdGetSypParam = new FbCommand();
>
> cmdGetSypParam.CommandText = "SYS_GET_PARAM";
Try to use here select * from SYS_GET_PARAM(@param, ...).
> cmdGetSypParam.CommandType = CommandType.StoredProcedure;
>
> cmdGetSypP
>> val = cmdGetSypParam.ExecuteScalar().ToString();
Sorry, I was thinking you're getting whole resultset.
--
Jiri {x2} Cincura
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
-
Take Surveys. Earn Cash.
; 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 v
[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
>
> Hel
Hello:
> 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!
>
What is the character set you are using
Mercea Paul wrote:
> cmdGetSypParam.CommandText = "SELECT PVALUE FROM SYS_PARAMETERS WHERE
> " +
>"(PAR_CODE = @pcode) AND (SUBSYSTEM =
> @psubsystem)";
This is not working (with "old" SP):
select * from SYS_GET_PARAM(@param, ...)
--
Jiri {x2} Cincura
ht
day, January 11, 2007 9:32 PM
> To: For users and developers of the Firebird .NET providers
> Subject: Re: [Firebird-net-provider] Error on geting value from stored
> procedure
>
> Hello:
> > Hi Carlos
> > I try putting @ before params and I get :
> > "Additional in
> > cmdGetSypParam.CommandText = "SELECT PVALUE FROM SYS_PARAMETERS
> WHERE
> > " +
> >"(PAR_CODE = @pcode) AND
> (SUBSYSTEM =
> > @psubsystem)";
>
> This is not working (with "old" SP):
> select * from SYS_GET_PARAM(@param, ...)
>
> --
> Jiri {x2} Cincur
> >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!
> >
> What is the character set you are
Mercea Paul wrote:
> Surprise!
> It's working like a charm.
Welcome back, man. :)
> In tabel structure luook like
> VARCHAR(30) CHARACTER SET ISO8859_2 COLLATE ISO8859_2.
>
> This could be the problem?
> I do I try to modify to none!
This problem still exists?
If so, maybe is problem with you
Hello:
> In tabel structure luook like
> VARCHAR(30) CHARACTER SET ISO8859_2 COLLATE ISO8859_2.
>
> This could be the problem?
> I do I try to modify to none!
>
Sorry what is the one you are using in the connection string ??
--
Carlos Guzmán Álvarez
Vigo-Spain
http://carlosga.wordpress.com
> Sorry what is the one you are using in the connection string ??
Coonection string :
connectionString="data source=192.168.1.250;initial catalog=gestiny;user
id=SYSDBA;password=masterkey" providerName="FirebirdSql.Data.FirebirdClient"
/>
--
Mercea Paul wrote:
>> Sorry what is the one you are using in the connection string ??
> Coonection string :
> connectionString="data source=192.168.1.250;initial catalog=gestiny;user
> id=SYSDBA;password=masterkey" providerName="FirebirdSql.Data.FirebirdClient"
> />
Try to add there character set.
15 matches
Mail list logo