firebird-net-provider

[Firebird-net-provider] FbCommandBuilder.DeriveParameters not retrive parameter size

[olegmad <ol...@ya...>]

Hello!

I create SP:

CREATE PROCEDURE TEST (
    WIN1251 VARCHAR(5) CHARACTER SET WIN1251)
RETURNS (
    UNICODE_FSS VARCHAR(5))
AS
begin
  "UNICODE_FSS" = 'test';
end

and execute code:

FbCommand sp_command = new FbCommand("TEST", connection, transaction);
sp_command.CommandType = CommandType.StoredProcedure;

FbCommandBuilder.DeriveParameters(sp_command);

when i looked into sp_command.Parameters array - i see - all Size = 0.

:(

Re: [Firebird-net-provider] FbCommandBuilder.DeriveParameters not retrive parameter size

[<car...@te...>]

Hello:

> I create SP:
>
> CREATE PROCEDURE TEST (
> WIN1251 VARCHAR(5) CHARACTER SET WIN1251)
> RETURNS (
> UNICODE_FSS VARCHAR(5))
> AS
> begin
> "UNICODE_FSS" = 'test';
> end
>
> and execute code:

Using this i get 2 params for sp_command:

            FbConnection connection = new FbConnection(connectionString);
            connection.Open();

            FbCommand sp_command = new FbCommand("SP_TEST", connection);
            sp_command.CommandType = CommandType.StoredProcedure;

            FbCommandBuilder.DeriveParameters(sp_command);

            connection.Close();



--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] FbCommandBuilder.DeriveParameters not

[olegmad <ol...@ya...>]

> Using this i get 2 params for sp_command:

A am too.

But sp_command.Parameter[0].Size - equal 0.

Re: [Firebird-net-provider] FbCommandBuilder.DeriveParameters not

[<car...@te...>]

Hello:

> A am too.
>
> But sp_command.Parameter[0].Size - equal 0.

Ahhh ok, mi fault i understand that you mean the parameters count, sorry.





--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] FbCommandBuilder.DeriveParameters not

[<car...@te...>]

Hello:

> A am too.
>
> But sp_command.Parameter[0].Size - equal 0.


Committed into CVS, i was filling only the needed data for execution, 
now i 'm filling to the Size, Precision and Scale of
sp parameters.



Thanks very much. :)


--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] FbCommandBuilder.DeriveParameters not

[olegmad <ol...@ya...>]

> Thanks very much. :)

Thank you :)