FiveTech Support Forums

FiveWin / Harbour / xBase community
Board indexActive topicsAll discussionsLogin (GitHub)
Board index FiveWin for Harbour/xHarbour Get data of Query in TMySQL problem
Marc Vanzegbroeck
Posts: 1195
Joined: Mon Oct 17, 2005 05:41 AM
Get data of Query in TMySQL problem
Posted: Wed Aug 08, 2012 07:09 AM
Hi,

I have a table 'btw' with fields 'ID' in first position and 'BTW' in second
When I run a query like
oQry = query('SELECT * FROM btw)


I can read the data of the field 'BTW' with
Code (fw): Select all Collapse
      oQry:GoTop()
      DO WHILE !oQry:eof()
            ? oQry:FieldGet(2)
          oQry:Skip(1)
      ENDDO


But when I use

oQry = query('SELECT "BTW" FROM btw)


? oQry:FieldGet(1) always return the text 'BTW' instead of the content of that field

How can I read the data of the field 'BTW' if I only want query that field

Thanks,
Marc
Regards,

Marc



FWH32+xHarbour | FWH64+Harbour | BCC | DBF | ADO+MySQL | ADO+MariaDB | ADO+SQLite
Marc Vanzegbroeck
Posts: 1195
Joined: Mon Oct 17, 2005 05:41 AM
Re: Get data of Query in TMySQL problem
Posted: Wed Aug 08, 2012 08:13 AM

Never mind, I just found the problem...

Marc

Regards,

Marc



FWH32+xHarbour | FWH64+Harbour | BCC | DBF | ADO+MySQL | ADO+MariaDB | ADO+SQLite

Continue the discussion

Static archive · New replies & topics via GitHub Discussions