Xailer & OZ Software

Hi,

We are facing a problem with Execute(), QueryArray() and QueryRow() methods from TMariaDBDataSource.
If the result has a big amount of data and the method is called again before the previous one has finished
processing, Xailer throws the error:

TMARIADBDATASOURCE:NEWERROR(615)
Erro XAILER/2014 Commands out of sync; you can't run this command now: MariaDB:SELECT * FROM teste
Argumentos: ()

We are sending attached the test project. Just click rapidly and repeatedly the button and Xailer will throw the
error.

MySql and MariaDB documentation says it occurs when you have 2 result sets open at the same time and to
avoid it, it's necessary to call the mysql_free_result() method.

Doesn't Execute(), QueryArray() and QueryRow() methods call it?
It can be fixed?

Thank you,

André Corrêa

André,

I'm affraid that the MySQL and MariaDB connectors (libmysql.dll and libmariadb.dll) don't allow to open two querys at the same time. So, you need to carry a flag to avoid it. F.e.:

Good morning jfgimenez,

If you test with the sample we have provided, you can see that the error persists.

André Corrêa.

André,

As I said before, you have to set a flag to avoid running a query twice at the same time. I've tested tour sample, and it raises an error as you said. Later, I've modified it by adding a property to the form:
And also changing the method BtnClick as so:
And then, the error vanishes.

There is another way to avoid those errors... setting this property on the datasource:
But this way causes that your program does not process any windows message while the datasource is busy. It could cause your program to be marked from windows as "program is not responding..."

jfgimenez,

We need more time testing, but It seems that setting lAllowProcessMessages to false solves our problem.

Thank you very much!

André Corrêa