MSStoredProc raises error when executing StoredProc what deletes duplicates

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
erva
Posts: 8
Joined: Sat 29 Feb 2020 15:59

MSStoredProc raises error when executing StoredProc what deletes duplicates

Post by erva » Tue 09 Jun 2020 16:17

MSStoredProc raises error when executing StoredProc what deletes duplicates. Error is "SQL statement doesn't return rows".

Is it possible to avoid this error, StoredProc deletes duplicates from table, doesn't return any data.

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

Re: MSStoredProc raises error when executing StoredProc what deletes duplicates

Post by Stellar » Mon 15 Jun 2020 08:05

Unfortunately, we can't reproduce the issue. To investigate this behavior of SDAC, please compose a small sample demonstrating the issue and send it to us, including database objects creating scripts.
You can send the sample using the contact form at our site: devart.com/company/contactform.html

erva
Posts: 8
Joined: Sat 29 Feb 2020 15:59

Re: MSStoredProc raises error when executing StoredProc what deletes duplicates

Post by erva » Fri 19 Jun 2020 06:32

Hi,

Problem is with SDAC, not with UniDAC.

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

Re: MSStoredProc raises error when executing StoredProc what deletes duplicates

Post by Stellar » Mon 22 Jun 2020 14:20

It was a typo, we've changed the answer.

Post Reply