sqlite query how work?

[faustf]

hi  guy  i  have read  some  part  of  sqlite manual ,  the  function   _SQLite_Query  ( in particular), i have  a questions  i try   to read  a  data  in table    my  table  have   8  column

with  2  row  (for the moment ),  but    result of  query   where do you go  and  in  wich format? ?

i try  to do

_SQLite_Query(-1, "SELECT * FROM configurazione ORDER BY nome;", $hQuery) ; the query

MsgBox (0,'leggo',$hQuery)

but  popup a  exadecimal value and  give me error 

!   SQLite.au3 Error
--> Function: _SQLite_Close
--> Error:    unable to close due to unfinalized statements or unfinished backups

 

some one  can  explae me  how  use  ???  thankz  att all

 

[faustf]

i  answer  me  i must  use   a frtch data  gunction  like  this 

 

While _SQLite_FetchData($hQuery, $aRow, False, False) = $SQLITE_OK ; Read Out the next Row
    ConsoleWrite(StringFormat(" %-10s  %-10s  %-10s  %-10s ", $aRow[0], $aRow[1], $aRow[2], $aRow[3]) & @CRLF)
WEnd

thankz at  all

 

[jchd]

Forget about these functions. Use _SQLite_GetTable2d, _SQLite_GetTable or _SQLite_QuerySingleRow as appropriate.