[Gambas-user] db retrieve

[Fabien Bodard]

dim hField as ResultField


For each hField in resQry.Fields

  Print hField.Name

Next





2009/11/26 Jean-Yves F. Barbier <12ukwn at ...626...>:
> Hi,
>
> How can I retrieve a "field" returned by a stored procedure?
>
> SP:
> CREATE OR REPLACE FUNCTION common.testbytea_sel(Pid OID) RETURNS TEXT AS $$
> DECLARE
>        MyPic           BYTEA;
>        MyString        TEXT;
> BEGIN
>        SELECT pic INTO MyPic FROM common.testbytea WHERE id = Pid;
>        MyString = encode(MyPic, 'base64');
>        RETURN MyString;
> END;
> $$ LANGUAGE PLPGSQL STRICT SECURITY DEFINER;
>
> GB:
> sqlQry = "SELECT * FROM common.testbytea_sel(" & RowNb & ");"
> resQry = $DBConn.Exec(sqlQry)
>
> PB: what resQry!??? shall I ask for?
>
> --
> Sorry, no fortune this time.
>
> ------------------------------------------------------------------------------
> Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
> trial. Simplify your report design, integration and deployment - and focus on
> what you do best, core application coding. Discover what's new with
> Crystal Reports now.  http://p.sf.net/sfu/bobj-july
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
>