Get free $10 credit @DigitalOcean

Hi guys,

Today I try DigitalOcean, and I have an offer to you guys, easily deploy an SSD cloud server on @DigitalOcean in 55 seconds. Sign up using my link and receive $10 in credit:

https://m.do.co/c/78ac2a8c666e

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!!!

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.