Re: [Firebird-net-provider] FBCommand problem

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

Hello:

> 1.1
> Don't have the exact code handy at the moment (its at work).
> However here is what it does. Declared two output parameters (id - integer
> and name - char(100)) and does the select id, name from test into :id, 
> :name
> I am not even sure if my proc is using the correct syntax as it seems 
> a very
> strange way of doing things.


Looks like this ??

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




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain