Fixed CTE bug with ZeosDBO

Today I check my email and I receive an email from Mark Daems (MVP of Zeos Component) and he inform me that the bug related with CTE (Common Table of Expression, the new Firebird 2.1 feature) already fixed, and I'm so happy that I can now use CTE feature with Zeos component without any problem. If you also use Zeos component then here is the fix:

Open ZAbstractRODataset.pas and make this patch and then recompile ZeosDBO.bpg:
{ Initializes field and index defs. }
- InternalInitFieldDefs;
+ if not FRefreshInProgress then
+ InternalInitFieldDefs;

if DefaultFields and not FRefreshInProgress then
CreateFields;

The (-) sign is the row of code that deleted and the (+) sign is the new one that added. The bug that I already found is in here.

Firebird Configuration Tool

Do you always make a change in Firebird database configuration setting? This nice & handy tool will safe you if you're a beginner or perhaps want to have more organize tool to edit the Firebird database configuration. That tool for me is more convenient than edit it manually with my favourite editor Notepad++.

What is Firebird database configuration setting? it's a "firebird.conf" file in your Firebird installation directory, it's a ordinary text file with some setting that effect the behaviour of your Firebird database. So thank's to Jhonny Suárez for his great contribution tool for Firebird communities.

Time to switch to ZeosDBO

Long time I not write in this blog. After I read in FirebirdNews.com that said IBObject (a component to direct access to Firebird/Interbase) is no longer free, it is due to the author problem that said in this IBObject support list. So why not switch to ZeosDBO that for long time ago always open source product and free. Now Zeos still in development in version 7 that will support BDS 2009 and the snapshot already can be used for experimentally. Here is the link to the Zeos forum