TMSQuery with FetchAll=False

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Sid
Posts: 5
Joined: Mon 30 Jan 2012 21:54

TMSQuery with FetchAll=False

Post by Sid » Thu 09 May 2019 19:21

Hi,

We are using SDAC Version 6.11.23 for RAD Studio 2007.

We are having an issue with TMSQuery Component used with FetchAll=False (FetchRows=100). This keeps the SQL query in the SQL Server in 'pending' state (releases only after the dbgrid has fetched all records). This 'pending' state locks all other SQL processes that require an exclusive use of the same table, ultimately causing a deadlock state. What can be done so the query when used with FETCHALL=FALSE does not keep itself in pending state in the SQL Server?

Thanks

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

Re: TMSQuery with FetchAll=False

Post by Stellar » Fri 10 May 2019 10:42

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

Post Reply