0
votes
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

Statistics

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

Visits by Source

User Actions

Users who voted for this posting

Subscribe:
Contact us to advertise on DelphiFeeds.com

Community Links

Torry Firebird News

Sponsor

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