Vote UpVote

When updates on a SELECT timeout with FireDAC, MSSQL 2016 and a ~8k varbinary field in the table

The Wiert Corner – A change of FetchOptions.CursorKind from ckAutomatic to ckDynamic does the trick. did fix this issue: I stumbled about a problem regarding FireDAC and MSSQL 2016. The table has four fields, one being of type varbinary(max). When I omit this blob field from the SELECT, I can update any field without problems using the edit and post methods of TFDQuery. It is only when I include that blob field in the SELECT, I cannot update the other fields anymore (the blob is not changed). The post runs into a timeout. It seems that the table is somehow locked. That guess is backed by the fact that even a ...
Favorite? Off-Topic? jpluimers @ 2018-04-26 07:04


Visits: 149
Votes: 0
Favorites: 0
Off-Topic: 0

Visits by Source

User Actions

Users who voted for this posting

Contact us to advertise on DelphiFeeds.com

Community Links

Torry Firebird News


Please login or register to use this functionality.
(click on this box to dismiss)