The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My badges

  • Twitter Updates

  • My Flickr Stream

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 2,230 other followers

Archive for April 26th, 2018

MijnJohn – – oud en jong hebben moeite met digitalisering: omdat alle mijn* verschillend werken.

Posted by jpluimers on 2018/04/26

[] MijnJohn –

“Ik ben er niet voor om het administratieve proces van mijn leveranciers te vereenvoudigen, ze zijn er om mijn administratieve processen te vereenvoudigen.”









Posted in Opinions | Leave a Comment »

Home – Outpan – GTIN to product attribute mapping

Posted by jpluimers on 2018/04/26

On my research list: Home – Outpan as it is a key-value store of EAN (actually GTIN, so including GS1 UPC, EAN which means barcodes like UPC-12, EAN-8, EAN-13 and ITF-14).


via [WayBack[How To] Scan a barcode and add the product name to Wunderlist : tasker


Posted in Cloud, Cloud Apps, Cloud Development, Development, Infrastructure, Internet, Power User, Software Development | Leave a Comment »

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

Posted by jpluimers on 2018/04/26

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 simple UPDATE query executed from Management Studio is also blocked until I reset my application inside the debugger.Interestingly an INSERT runs without problems.

Via: [WayBack] I stumbled about a problem regarding FireDAC and MSSQL 2016…. G+ Uwe Raabe


Posted in Delphi, Development, Software Development | Leave a Comment »

%d bloggers like this: