Re: [Firebird-net-provider] FBCommand problem

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

Hello:

It's working for me (.net 1.0).

A more correct version :

CREATE PROCEDURE SELECT_DATA
RETURNS (
    INT_FIELD INTEGER,
    VARCHAR_FIELD VARCHAR(100),
    DECIMAL_FIELD DECIMAL(15,2))
AS
begin
    FOR SELECT INT_FIELD, VARCHAR_FIELD, DECIMAL_FIELD FROM 
TEST_TABLE_01 INTO :INT_FIELD, :VARCHAR_FIELD, :DECIMAL_FIELD
    DO
        SUSPEND;
end

This is bad:

       Console.WriteLine("(0) {1}", reader.GetValue(0), reader.GetValue(1));

needs to be:

       Console.WriteLine("{0} {1}", reader.GetValue(0), reader.GetValue(1));


--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain