Devart Forums

using MyDAC 4.40.0.18 for Delphi 5

My app worked fine with MyDAC 4.00.1.6 but loses the connection on some querys after the upgrade. I have tried changing the settings as per FAQ but no luck.

I use a TMyQuery / TDataSetProvider / TClientDataSet

The SQL is: "select * from test_table". It is a small table and I want to insert a small number of rows. It is fine for a couple of rows but later bombs with the above error.

If I use just the TMyQuery with CachedUpdates, all is fine. When combined with TDataSetProvider / TClientDataSet it bombs when I call ApplyUpdates and before it reaches the BeforeUpdateRecord procedure.

thxs

We could not reproduce the problem. Please try to determine any dependences. Does the problem appear depending on some row types (e.g. BLOB fields) or it appears depending on inserted values or something else. Also check if any settings of the MySQL Server were changed. If you are unable to find the reason of the problem then send us (evgeniyD*crlab*com) a complete small sample to demonstrate the problem, including script to create and fill test table. Also supply us with exact version of MySQL server. You can see it in Info sheet of TMyConnection Editor.

Thank you for sample. It did help us very much. We have fixed this problem. This fix will be included in the next MyDAC build.

Antaeus wrote:Thank you for sample. It did help us very much. We have fixed this problem. This fix will be included in the next MyDAC build.

is this fix in 4.30.1.19? I get the same problem sometimes.

thanks,

Snorkel

Same with me!

Started when I used FetchAll = False

I set it back to True but the message still coming when I close my programme.

No, this fix was not applied to MyDAC 4.40.0.19 it will be applied to the next MyDAC build.