[Gambas-user] Extracting fields from a Result

[Doug Hutcheson]

On Tue, 2018-01-09 at 11:29 +1000, Doug Hutcheson wrote:
> On Mon, 2018-01-08 at 12:55 +0100, Benoît Minisini wrote:
> > Le 31/12/2017 à 02:44, Doug Hutcheson a écrit :
> > > Hi everyone.
> > > 
> > > I have successfully connected to my PostgreSQL database and the
> > > field 
> > > count in the Result from my query is correct, but all my attempts
> > > to 
> > > extract data from the fields have failed. I am cobbling together
> > > code 
> > > from the wiki and from other posts here, but I am still missing
> > > something.
> > > 
> > > The table I am reading from has exactly one row and 35 fields.
> > > The first 
> > > field is named txtMasterDatabase.
> > > 
> > > My code declares a Field and a Result as follows:
> > >            Dim $Field As ResultField
> > >            Dim $Result As Result
> > > 
> > > The query works correctly:
> > >             $Query = "Select * From abpa.tblParameters"
> > >             $Result = $Con.Exec($Query)
> > > 
> > > The field count is correct - 35:
> > >             Message("Fields count = " & $Result.Fields.Count)
> > > 
> > > Now I try to loop through the fields in the result:
> > >             For Each $Field In $Result.Fields
> > >              Message($Field.Name)
> > >             Next
> > > 
> > > The problem occurs on the For Each line in that the Basic IDE
> > > displays 
> > > an error at this point:
> > > Unknown field: txtMasterDatabase in FRMStart:41
> > > 
> > > As I said above, the first field in the tuple is named 
> > > txtMasterDatabase, so Gambas is at least seeing it. Why is it
> > > telling me 
> > > the field is unknown?
> > > 
> > > Thanks for any help and Happy New Year,
> > > Doug
> > > 
> > 
> > It should be fixed with commit 
> > https://gitlab.com/gambas/gambas/commit/36132fa99abeba8549b127a1438
> > d5b3d29d88f2c.
> > 
> > Regards,
> > 
> Thank you Benoît - I will test it today.
> Regards,
> Doug

An excellent job - it works perfectly!
The more of Gambas I learn, the more I like it.
Kind regards,
Doug
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.gambas-basic.org/pipermail/user/attachments/20180109/72ffe686/attachment.html>