[Gambas-user] Extracting fields from a Result

[Fabien Bodard]

It seem the field txtMasterDatabase does'nt exist.

I think i need the whole source hto understand the problem




2017-12-31 7:26 GMT+01:00 Doug Hutcheson <owlbrudder at gmail.com>:
> 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
>
>
>
> --------------------------------------------------
>
> This is the Gambas Mailing List
> https://lists.gambas-basic.org/listinfo/user
>
> Hosted by https://www.hostsharing.net
>



-- 
Fabien Bodard