Devart Forums

Hi all,

we have huge problem after upgrade Unidac to 7.2. We use TClientDataset-TDatasetProvide-TUniQuery to post data. Starting from version 7.2 one extra sql call is made before apply updates. It completely slow down applyupdates at all.

Example:

CDS.CommandText:='select * from TABLE where ID=10';
CDS.Open;
CDS.Insert;
...
CDS.Post;
CDS.ApplyUpdates(0); -- HERE TWO SQL EXECUTE

One sql is exact as in CommandText and the second is right INSERT INTO ....

Have I missed something in Options?

Thanks
Zdenek

Thank you for the information. We reproduced the specified difference in behavior and are investigating it now. We will let you know about the results.

Perfect. Thanks

Zdenek

We fixed the issue. This fix will be included in the UniDAC next build.

If you want to get it before the official release, use the contact form at our site: https://www.devart.com/company/contactform.html and provide us with UniDAC license number, as well as the email address where the night build can be sent to.

Thanks. I can wait for official release.

Zdenek

I have a similar problem:
clientdataset -> qdetail (tdatasetfield)

qmaster.sql.text: = SELECT * FROM MASTER
cdsmaster (clientdataset) -> provider -> qmaster:
here I use the dbedits connected to the clientdataset, if I am in the registry number 1 okay, more if I do:
qmaster.close;
qmaster.sql.text: = 'SELECT * FROM MASTER WHERE ID = 2';
qmaster.open;
cdsmaster.refresh -> I use to try to update the dbedits on the screen, therefore I did not find another way to position the clientdataset -> clientdataset error: Record not found or changed by another user

how to proceed, do you have some example of using clientdataset with uniquery and selecting a specific record in the query?

In order for us to be able to give you a detailed answer, we need to have a sample demonstrating the specified behavior. Therefore, please compose a small sample demonstrating the described behavior and send it to us using the contact form https://devart.com/company/contactform.html, including the scripts for creating database objects.

We try to move from 7.1 to 7.3 but still have problems with extra select. We have to stuck in 7.1, It's not good situation.

We cannot reproduce this issue on the latest version of UniDAC 7.3.9. Please send us a test project to reproduce it using the contact form at our site: https://devart.com/company/contactform.html . In the sample, also include the script for creating a test table.

Problem is with UpdateMode - keyOnly, I think. I will send an example code.

Thank for the sent sample. We reproduced the issue and are investigating it now. We will inform you about the results.