Story Category: Database Development
VOTEdelphi – How to enable wirecompression on Firebird 3.0 – Stack Overflow
jpluimers
For my link archive: [WayBack] delphi – How to enable wirecompression on Firebird 3.0 – Stack Overflow [WayBack] delphi – How to enable WireCompression on Firebird 3.0 using FireDAC – Stack Overflow –jeroen – Details…
4 months ago in Database Development, Delphi, Development, Firebird, Software Development
0
ODAC: calling SYS.DBMS_SESSION.SET_NLS failing with ORA-06550/PLS-00103
jpluimers
Do not call SYS.DBMS_SESSION.SET_NLS with an instance of the [Archive.is] TOraStoredProc Class, as under the hood, it will translate the call to this: Class:Ora.TOraStoredProc;Component:sprSetNls;Flag:tfQPrepare,Text:Prepare: begin SYS.DBMS_SESSION.SET_NLS(:PARAM, :VALUE); end; :PARAM(VARCHAR[22],IN)=’NLS_NUMERIC_CHARACTERS’ :VALUE(VARCHAR[4],IN)=”.,” The above is a translation… – Details…
4 months ago in Database Development, Delphi, Development, OracleDB, Software Development
0
ODAC undocumented exception ‘Need Oracle 8 Call Interface’
jpluimers
I got this when taking over maintenance of some legacy code that called a stored procedure in a : ————————— Debugger Exception Notification ————————— Project LegacyProject.exe raised exception class Exception with message ‘Need Oracle 8… – Details…
4 months ago in Database Development, Delphi, Development, OracleDB, Software Development
0
SQL Server: RowVersion is not the same format as BigInt
jpluimers
A while ago, I needed to get RowVersion binary data out of SQL Server. People around me told me it is stored as BigInt. I luckily bumped into [WayBack] sql server – Cast rowversion to… – Details…
5 months ago in .NET, Database Development, Delphi, Development, Software Development, SQL Server
0
FireDAC 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…
1 year 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…
2 years ago in Database Development, Delphi, Development, Office VBA, Scripting, Software Development, SQL, SQL Server
0