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
TMSQuery with FetchAll=False
Re: TMSQuery with FetchAll=False
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
You can send the sample using the contact form at our site: devart.com/company/contactform.html