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

count(*) VS count(somefield)

What is the difference between "select count(*) from sometable" and "select count(somefield) from sometable"? The answer is simple, the "count(*)" will count all the record on that table. The "count(somefield)" will count all the record which is that field is not null. So the result of that 2 query may different. Example:
I have a table foo which has the record like this:

id name
1  XXXXX
2  YYYYY
3  
4  

select count(*) as cntall, count(name) as cntname from foo
The result of the above query is:
cntall cntname
4      2

The Future of Zeos

Here is the link about the future development of Zeos. Thank's Mark for the news :) also I hear from Mark (ZeosLib Most Valuable Person) that he receive invitation to attend in Firebird Conference!! it's look that Zeos get famous among Firebird user that use Delphi or Lazarus. It's a great news, you must attend Mark :) we support you.

08.08.08 Version Phenomena

08.08.08 is a lucky number in Chineese tradition as in the opening of the Beijing Olympic 2008. But also many software that release it stable version on that day :) for example here is my favourite software that has 08.08.08 release version:
1. ZeosDBO (look at my previous posting)
2. CnPack IDE Wizards (open source Delphi add-on like GExpert)
3. IBExpert Personal Edition (free version of IBExpert, the famous Firebird GUI management)

If you also use that software then probably you want to check out it's new version :) Happy download and wish Beijing Olympic 2008 held with success.

ZeosDBO 6.6.3-stable is Released

Today (the same day with the opening of the Beijing Olympic Games 2008) ZeosLib version 6.6.3 stable is officialy release. The list of the download files (the component itself and the documentation) can be found here

Thank's for this great components. Bravo ZeosLib Development Team!!!