Devart Forums

Hi Jeremy,
Thanks for contacting us!

Please describe your issue more precisely.
Send the full text of your error and describe the exact steps of action leading to this error.

Also, kindly note that the issue described in this thread has been fixed and the fix will be included in the next build of our product.

If your case is related to the issue described above and you need to apply this fix now, please specify your license number, IDE version and send us via this contact form: https://www.devart.com/company/contactform.html

Hi there!
You are always welcome.

Should you have any product related questions, do not hesitate to ask!

Hi,
Thanks for your request!

Please note, that currently, UniDAC's "Filter" property does not support such filter expressions using SQL functions.

To use such expressions, you can use the "FilterSQL" property.
Example:
...
UniQuery.FilterSQL := '(Day(aDATA) = 20) and (Month(aDATA) = 07) and (Year(aDATA) = 2022)';
...

You can find more information about the "FilterSQL" property using the link to our documentation:
https://docs.devart.com/unidac/devart.d ... tersql.htm

We'll explore the possibility of using such filtering conditions in a regular "Filter" property.

Hi there,
Thanks for your request!

Please describe your issue in more detail and send us the screenshot demonstrating the issue.
Also, kindly send us the exact list of actions (steps) after which this error appeared.

Additionally, please clarify what database you are working with and its version?

Kindly note that we are not aware of any issues related to the use of our components and visual components such as CxGrig.

You can create a sample using the standard TClientDataSet component and CXGrid, and in case of a similar problem, ask the CXGrid developers a question.

Also, please check if the issue is reproducible using UniDAC and the standard TDBGrid component?

Hi, Tobias
Thanks for contacting us!

Kindly note, that we were unable to reproduce the "Lost connection to mysql server during query" error you mentioned based on the data you provided.

So could please compose and send us an sample application reproducing the error you have specified with all necessary DDL and DML scripts to create and populate database objects.
You can send all the needed samples via the e-support form: https://www.devart.com/company/contactform.html

Also, please send us the exact list of steps (actions) which leading to the error you indicated.
You can create and send us the screenshot demonstrating the issue.

Additionally, could you please clarify some additional information:
- What version of MyDAC do you have;
- What version of RadStudio;
- What version of the database;

Hi,

We've reproduced the issue and fixed it. The fix will be included in the next build of our product.
As a workaround, we can send you a nightly build of our product including the required changes.
Please specify your license number, IDE version and send us via this contact form: https://www.devart.com/company/contactform.html

Hi,
Thanks for contacting Devart blog!

Kindly be informed that we've reproduced the issue regarding the "Accessor is invalid" error and fixed it.
The fix will be included in the next build of our product.

As a workaround, we can send you a nightly build of our product including the required changes.

Please specify you license number, IDE version and send us via the contact form: https://www.devart.com/company/contactform.html

Also, please clarify what do mean by saying this - "We see that you are overriding our request for a serializable transaction by changing it to read committed."

Hi Lucas,
Thank you for the additional information provided.

Please note, that we've reproduced the issue you mentioned with incorrect display of fractional parts for fields with the BCD type, and found that the error occurs precisely in Delphi 10.4 version 27.0.37889.9797, which you pointed out to us earlier.

We also made comparisons with versions 10.4, 10.4.2 and 11.1.

Therefore, please update your IDE to version 10.4.2 or higher to fix the issue.

Hi,
Thanks for contacting Devart blog!

Please submit your example to our support team via the contact form: https://www.devart.com/company/contactform.html

Also please clarify some additional information:
- what version of IBDAC do you have;
- version of FireBird;
- version of IDE;

Hey Lucas,
Thanks for getting back to us!

Kindly be informed, that we were unable to reproduce the issue you mentioned.
In our environment, the result of the application we sent you earlier looks like this:


Please note, that we are still investigating this issue.
We will let you know as soon as we have the results.

Hi,
Thank you for the provided information.

We have reproduced the issue and will investigate its origin.
We will inform you about the results shortly.

Hey,
Thanks for contacting us!

Kindly note, that we were unable to reproduce the "Unknown column MODIFIED in field list" error you mentioned based on the data you provided.
So could please compose and send us an sample application reproducing the error you have specified with all necessary DDL and DML scripts to create and populate database objects.
You can send all the needed samples via the e-support form: https://www.devart.com/company/contactform.html

Also, please send us the exact list of steps (actions) which leading to the error you indicated.
You can create and send us the screenshot demonstrating the issue.

Additionally, could you please clarify some additional information:
- What version of MyDAC do you have;
- What version of RadStudio;
- What version of the database;

Hi there,
Thanks for contacting us!

Could you be so kind to tell what exactly you haven't verified by end using our ODBC Driver?
Please submit your descriptions to our support team via the contact form: https://www.devart.com/company/contactform.html

Also, please specify which ODBC driver you are talking about in the description.

Hi there!
Thanks for contacting us.

To work with MySQL, our UniDAC and MyDAC products contain components responsible for data backup.
You can learn more about the products by following the links:
https://www.devart.com/unidac/
https://www.devart.com/mydac/

For UniDAC it is a TUniDump component - the class that serves for storing data from tables or editable views as a script and for restoring data from a received script. TUniDump works on the client side.

For MyDAC it is TMyDump and TMyBackup components.

TMyDump - a component for storing database or its parts as a script and also for restoring database from the received script. TMyDump works on the client side.

TMyBackup - a component that serves for backup copying specified tables on the server. TMyBackup works on the server side.

You can read about using components in our online documentation at the following links:
- TUniDump: https://docs.devart.com/unidac/devart.u ... nidump.htm
- TMyDump and TMyBackup:
https://docs.devart.com/mydac/devart.mydac.tmydump.htm
https://docs.devart.com/mydac/devart.my ... backup.htm

To get acquainted with UniDAC and MyDAC products, you can download and install the Trial version:
https://www.devart.com/UniDAC/download.html
https://www.devart.com/MyDAC/download.html

Hi,
Thanks for contacting us!

Could you please describe your issue in more detail?
What kind of errors occur and what actions cause them?

Please create and send us the screenshots demonstrating the issue.