RE: [Firebird-net-provider] FBCommand problem

[Derek E. <de...@sp...>]

Yup that=92s it.

-----Original Message-----
From: Carlos Guzm=E1n =C1lvarez [mailto:car...@te...]=20
Sent: Tuesday, 28 October 2003 10:54 p.m.
To: Derek Ekins
Cc: fir...@li...

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=20
> 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 =20
WHERE INT_FIELD =3D 2 INTO :INT_FIELD, :VARCHAR_FIELD, :DECIMAL_FIELD;
    suspend;
end




--
Best regards

Carlos Guzm=E1n =C1lvarez
Vigo-Spain