how to call mysql_free_result() in zeos component in my project
lazarus / 16-Databases

----------------------------------------------------------------------
delphi887 · 2012-01-09 05:34

hi
i am working with Lazarus 0.9.30.2 and zeos component in my project .
in datamodule put a connection to mysql 5.5 and many table and query
(about 28 table and query)
when opening a tabale or query after processes close it and open
another table and query .
problem : when opening late table mysql error : Commands out of sync
ref in mysql website : 
http://dev.mysql.com/doc/refman/5.0/en/commands-out-of-sync.html
now how fix open or close tables or query ?????
Forgive me if  my English is bad .

----------------------------------------------------------------------
ludob · 2012-01-09 11:19

zeos is calling mysql_free_result() when closing a result set, table
or query. If you are not using 'useresult=yes' in the connection or
statement parameters then zeos uses storeresult.

There is a known out of sync problem with the mysql driver and
resultsets returned from stored procedures. See
http://zeosbugs.firmos.at/view.php?id=220 and
http://zeosbugs.firmos.at/view.php?id=235. The last one includes a
non-committed patch.

----------------------------------------------------------------------
delphi887 · 2012-01-10 06:49

Thanks