[Gambas-user] Extracting fields from a Result

[Doug Hutcheson]

This just gets more interesting.
The For Each ... Next loop fails on the first line, as previously
described.
After some bashing and hacking, I found a simple loop works
fine:              For intLoop = 0 To MyResult.Fields.Count -
1                Message(MyResult.Fields[intLoop].Name & ": " &
MyResult[intLoop] & ": " & MyResult.Fields[intLoop].Length & ": " &
MyResult.Fields[intLoop].Type)              Next
Given a field named txtMasterDatabase, should the following work?	
	Message(MyResult!txtMasterDatabase)... because it throws
'Unknown field txtMasterDatabase ..."
Many thanks for help on this.
Kind regards,Doug
On Sun, 2017-12-31 at 12:00 +1000, Doug Hutcheson wrote:
> 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/2b27e6e5/attachment.html>