[Resolved] Having "Operation Canceled" during form close with ChangeNotification component

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
pigbbong
Posts: 9
Joined: Wed 30 Jul 2014 07:17

[Resolved] Having "Operation Canceled" during form close with ChangeNotification component

Post by pigbbong » Wed 30 Jul 2014 07:29

I'm having the following message during terminate my application from Delphi. But this 3 message wont show after I build it into exe.

https://www.dropbox.com/s/ue05srwj7vjclt2/error.png

Message:
1) Operation canceled.
2) OLE DB error occurred. code 80040E4Eh.
3) OLE DB error occurred. code 80040E4Eh, Operation canceled.

I using Delphi 2007, my DB is MSSQL 2008 and SDAC version is 6.10.19.
Last edited by pigbbong on Mon 04 Aug 2014 01:58, edited 1 time in total.

azyk
Devart Team
Posts: 1119
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: Having "Operation Canceled" during form close with ChangeNotification component

Post by azyk » Wed 30 Jul 2014 13:59

Thank you for the information. Such behavior occurs on incorrect closing of dataset with the ChangeNotification property being set. It is due to our internal errors, that we handle by ourselves. This is correct behavior, and a user won't see these errors in a working application.

pigbbong
Posts: 9
Joined: Wed 30 Jul 2014 07:17

Re: Having "Operation Canceled" during form close with ChangeNotification component

Post by pigbbong » Wed 30 Jul 2014 14:58

Have this been fixed in version 6.10.20?

azyk
Devart Team
Posts: 1119
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: Having "Operation Canceled" during form close with ChangeNotification component

Post by azyk » Fri 01 Aug 2014 11:47

This is correct behavior, and a user won't see these errors in a working application. We do not see possibility to change it.

pigbbong
Posts: 9
Joined: Wed 30 Jul 2014 07:17

Re: Having "Operation Canceled" during form close with ChangeNotification component

Post by pigbbong » Mon 04 Aug 2014 01:57

Ok thanks for your clarification. :D

OlliWW
Posts: 25
Joined: Mon 25 Mar 2013 17:03

Re: [Resolved] Having "Operation Canceled" during form close with ChangeNotification component

Post by OlliWW » Thu 17 Jan 2019 13:01

I'm having this issue too.
Any news on this topic?
Its very confusing in a project with many developers, since you need to tell everybody "no no that's fine, just ignore that" :(

Stellar
Devart Team
Posts: 496
Joined: Tue 03 Oct 2017 11:00

Re: [Resolved] Having "Operation Canceled" during form close with ChangeNotification component

Post by Stellar » Wed 23 Jan 2019 14:54

As we wrote before, this behavior is correct. When closing the data set with the installed ChangeNotification property, exceptions may occur. These exceptions are internal and are not transmitted into an application.
The generation of errors when they occur is standard practice in Delphi.

Post Reply