[Gambas-user] Extracting fields from a Result

[Doug Hutcheson]

Darn. Still getting used to the conventions. I should have said I am
running Gambas 3.10.0 on Fedora 28 Linux.

On Sun, 2017-12-31 at 11:44 +1000, Doug Hutcheson wrote:
> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.gambas-basic.org/pipermail/user/attachments/20171231/a97c6e6f/attachment-0001.html>