Selasa, 05 Januari 2010

ZeosDBO 6.6.6 is Out

The Zeos Development Team announce the reelase of ZeosDBO 6.6.6 -stable and the alpha version of ZeosDBO 7.0. The maintenance version of ZeosDBO 6.6.6 already include the bug fix of the Firebird CTE (Common Table of Expression) bug that I already describe earlier in this blog. So hope this new year update from Zeos Development Team can be a new year gift for us. Happy New Year 2010 everyone!!!

Senin, 21 Desember 2009

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

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.

Kamis, 21 Mei 2009

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.

Selasa, 10 Maret 2009

Time to switch to ZeosDBO

Long time I not write in this blog. After I read in 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

Rabu, 19 November 2008

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

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

Minggu, 14 September 2008

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.

Minggu, 10 Agustus 2008

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.