Getting exception when closing TMyQuery

[piedsoftware]

Hi,

I'm testing out the effects of the FetchAll property, because we have been having slowness issues with TMyQuery.

I find that I am getting EMySqlException "Lost connection to MySQL server during query" when closing a TMyQuery with FetchAll false.

Any ideas why this might be happening?

TIA
Mark

[AndreyZ]

Hello,

Such MyDAC behaviour is correct, it is caused by specificity of working with not fetched data. You will see the 'Lost connection to MySql server during query' error only if you run your application from IDE. You will not see this error when you run the executable file of your application.

[piedsoftware]

Thanks, that makes sense.

[AndreyZ]

You are welcome. Feel free to contact us if you have any further questions about MyDAC.