[Gambas-user] Extracting fields from a Result

[PICCORO McKAY Lenz]

yeah Tobias, it's due postgres of coourse its for scalar grade and more
fine tune things.. of course with mysql and sqlite will  not fail..

with postgres and odbc fail as the other already now confirmed, i reported
some time ago similar problems.. but due i was busy does not paid
attention..

i still must test and made some other fine tune agains the odbc updates in
gambas, i have many expoerience with but gambas must be still compile-able
in my ery olders linuxes

also i take a look to the stalled web-cam and vide4linux gambas module and
seems one of my manpowers at the job can made something.. but for now
there's many work in load..

Lenz McKAY Gerardo (PICCORO)
http://qgqlochekone.blogspot.com

2017-12-31 18:56 GMT-04:00 Doug Hutcheson <owlbrudder at gmail.com>:

> Good idea Lee - I will fire up MySql on my machine and try a similar
> approach.
>
> Using PostgreSQL, the For loop using a loop index works perfectly, showing
> the field names and the data, but the For Each loop fails on the 'For Each
> ... ' line.
>
> I will get back to the list about MySql.
>
> Doug
>
> On Sun, 2017-12-31 at 12:49 -0500, T Lee Davidson wrote:
>
> Yes, MyResult!txtMasterDatabase should work. (Did you copy/paste that name, or type it in directly?) The For Each loop should
> work as well.
>
> I tried a simple command-line application on a MySQL data table with just one row. All the application does is, first connect to
> the database, and then 'MyResult = hConn.Exec("select * from users")'
>
> A For Each loop prints the field names just fine. And, 'Print MyResult!id' displays the correct value.
>
> Perhaps there is a bug in the Gambas PostgreSQL driver. Can you test on a MySQL table to see if that works for you?
>
>
>
>
>
> --------------------------------------------------
>
> This is the Gambas Mailing List
> https://lists.gambas-basic.org/listinfo/user
>
> Hosted by https://www.hostsharing.net
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.gambas-basic.org/pipermail/user/attachments/20171231/b7293e22/attachment.html>