Re: [Gambas-user] db retrieve

2009-11-26 Thread Jean-Yves F. Barbier
Benoît Minisini a écrit : ... > > You can access result fields by index too: > > resQry[0], reqQry[1], ... Haaa this sounds very good too :) -- Bringing your mate to a convention is like taking a game warden hunting.

Re: [Gambas-user] db retrieve

2009-11-26 Thread Benoît Minisini
> 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; > MyStringTEXT; > BEGIN > SELECT pic INTO MyPic FROM common.testbytea WHE

Re: [Gambas-user] db retrieve

2009-11-26 Thread Fabien Bodard
dim hField as ResultField For each hField in resQry.Fields Print hField.Name Next 2009/11/26 Jean-Yves F. Barbier <12u...@gmail.com>: > 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

[Gambas-user] db retrieve

2009-11-26 Thread Jean-Yves F. Barbier
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; MyStringTEXT; BEGIN SELECT pic INTO MyPic FROM common.testbytea WHERE id = Pid;