Get data of Query in TMySQL problem

[Marc Vanzegbroeck]

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: Select all  Expand view

     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

[Marc Vanzegbroeck]

Never mind, I just found the problem...

Marc