Devart Forums

Hello, I've been using UniDAC for quite some time, and I think I've found a problem in the latest UniDAC version.

Sometimes I use quoting around column names, since I sometimes need to quote a column name that is a reserved word (this is a problem due to converting från MySQL -> PostgreSQL).

Anyway, in version 4.1.4 this doesn't seem to work for the MySQL provider.

Example - this used to work:

UPDATE table_x SET "end" = CURRENT_TIMESTAMP WHERE id = 1;

This still works for the PostgreSQL provider, but not anymore for MySQL - instead an error of bad syntax i raised. Is this a bug, or is there a setting that must be enabled in later versions?

In the 3.70.0.17 version this worked, but not anymore in 4.1.4.

I'm using Delphi 2006.

/Peter

Hello,

Thank you for the information. We have reproduced and fixed this problem. This fix will be included in the next UniDAC build.

Thanks for the reply. Is it possible to get a source diff for the fix, so I cen get it implemented right now? I do have UniDAC with source, so I would appreciate if this is possible.

/Peter

Please send me an email to andreyz*devart*com with your UniDAC license number. I will send you source files with needed corrections.