Story Category: Database Development
VOTEFireDAC can do DBMS back-end conditional SQL via Conditional Substitution
jpluimers
Though the field-types mentioned in the problem and solution are equal (so either is wrong), the solution in [WayBack] I have a little problem with FireDAC and the TStringField and TWideStringField design time generation… – Juan… – Details…
8 months ago in Database Development, Delphi, Development, Firebird, InterBase, Software Development, SQL, SQL Server
0
In SQL Server use `SET NOCOUNT ON` so tools taking the last modified record count won’t be confused by your trigger.
jpluimers
Interesting read: Time eating bug of the day… – Fabian S. Biehn – Google+. TL;DR: in SQL Server use SET NOCOUNT ON so tools taking the last modified record count won’t be confused by your trigger…. – Details…
1 year ago in Database Development, Delphi, Development, Office VBA, Scripting, Software Development, SQL, SQL Server
0