Why Uniquery.ApplyUpdates not successful?

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
ys990819
Posts: 8
Joined: Tue 26 Nov 2013 02:36

Why Uniquery.ApplyUpdates not successful?

Post by ys990819 » Tue 07 Jan 2014 16:03

when I put Uniquery,UniDataSource,UniUpdateSQL on a Form.
Set properties like this:
UniDataSource.DataSet := UniQuery;
UniQuery.UpdateObject := UniUpdateSQL;
//and I generate UniUpdateSQL insert\Update\Delete SQL Code on the form;

I define UniQuery.AfterpPost event Code like this:
UniQuyer.ApplyUpdates;

I define UniQuery.AfterDelete event Code like this:
UniQuyer.ApplyUpdates;

but when I wrote this code to Insert or Delete records,Insert is successful,but Delete is not successful.

UniQuery.Close;
UniQuery.Open;
UniQuery.Insert;
UniQuery.FieldByName('TEST').Asstring := 'AAAA'; //Key Filed
...
UniQuery.Post; //the record was be inserted to MSSQL sucessful;
//then i run this
UniQuery.Delete; //the record 'AAAA' can not be Deleteed,and i user sql server profile,
//can not trace any SQL CODE

Can you help me how to solve this problem?

Thanks a lot.

ys990819
Posts: 8
Joined: Tue 26 Nov 2013 02:36

Re: Why Uniquery.ApplyUpdates not successful?

Post by ys990819 » Thu 09 Jan 2014 00:48

Mark.

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Why Uniquery.ApplyUpdates not successful?

Post by AlexP » Thu 09 Jan 2014 13:47

Hello,

Thank you for the information, we have reproduced the problem and will try to fix it as soon as possible.

ys990819
Posts: 8
Joined: Tue 26 Nov 2013 02:36

Re: Why Uniquery.ApplyUpdates not successful?

Post by ys990819 » Wed 15 Jan 2014 06:26

AlexP wrote:Hello,

Thank you for the information, we have reproduced the problem and will try to fix it as soon as possible.

Thank you very much.

when could I download the new version components?
because I am worry about my projects.

Thanks a lot.

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Why Uniquery.ApplyUpdates not successful?

Post by AlexP » Wed 15 Jan 2014 11:14

Hello,

We plan to release a new version in the end of this - beginning of the next month.

ys990819
Posts: 8
Joined: Tue 26 Nov 2013 02:36

Re: Why Uniquery.ApplyUpdates not successful?

Post by ys990819 » Tue 18 Mar 2014 10:37

AlexP wrote:Hello,

We plan to release a new version in the end of this - beginning of the next month.

Is this problem be resolved?

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Why Uniquery.ApplyUpdates not successful?

Post by AlexP » Fri 21 Mar 2014 14:03

Yes, the problem is already fixed, the fix will be included to the next version.

Post Reply