Delphi-PRAXiS - When updates on a SELECT timeout with FireDAC, MSSQL 2016 and a ~8k varbinary field i

Delphi-PRAXiS (https://www.delphipraxis.net/forum.php)

- Delphi-News aus aller Welt (https://www.delphipraxis.net/58-delphi-news-aus-aller-welt/)

- - When updates on a SELECT timeout with FireDAC, MSSQL 2016 and a ~8k varbinary field i (https://www.delphipraxis.net/196138-when-updates-select-timeout-firedac-mssql-2016-%7E8k-varbinary-field-i.html)

DP News-Robot

26. Apr 2018 06:10

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

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 […]

Alle Zeitangaben in WEZ +1. Es ist jetzt 09:19 Uhr.