One of the issues I recently faced while working with Firebird was how to use a string within a 'Execute Statement'. For example, This throws an error. though the answer looked farely simple when done. You need to two Single Quotes. There might be another situation, when you need to append string based on … Continue reading Appending Strings and Parameters in Firebird.
Firebird 3.0 Issues
Migrating to Firebird 3.0 has been routine that caused more headache than expected. One of most common, yet pestering error was "Your user name and password are not defined". Interestingly, it worked perfectly fine when we were using the Firebird 4.10 Ado.net Nuget, however, the moment we update our Nuget package to 5.7, we are … Continue reading Firebird 3.0 Issues
Search Tables with Known Column Name
Have you ended up in a situation wherein, you know the Column Name but you have no clue about the Table Name ? I recently came across the situation and following is one query which help me out of the situation.The Query is for Firebird Database.
Batch Execution in Firebird
Executing a .sql file on Firebird Database can be quite a messy job. The lack of proper documentation and support would hurt you more when encountered issues and that is what I faced when I required to do execute contends of a .Sql File. Having understood that FbBatchExecution is the command I would required, I went to … Continue reading Batch Execution in Firebird