Re: Recommendation

From: Lee (lee_jenkins_at_No_Spamming_datatrakpos.com)
Date: 05/30/04 

Date: Sun, 30 May 2004 14:40:34 -0400

> The only downside to Firebird is it does not support Boolean, and AutoInc
> fields. It uses generators and triggers to accomplish AutoInc. If you
> switch your dataset components to IBO or IBX, they automatically handle
> these little nuances for you. Booleans are not an issue, its a matter and
> changing code FieldByName('BoolField').AsBoolean to
> (FieldByName('BoolField').AsString = 'Yes'), or
> (FieldByName('BoolField').AsInteger = 1) (etc.,etc.,etc.) on reads and
> making a function (i.e. FieldByName('BoolField').AsString :=
> BoolValue(BooleanField) (returns: yes/no)) for updates.
>

I agree. I've always just used 1/0 to indicate true false values since most
dbCheckBoxes allow you to indicate the true/false values to return.
Firebird is an awesome product. We recently installed a system with 35
workstations creating over 18,000 sales transactions in a single day. Very
reliable.

Of course, not to take anything from NexusDB....all I see are people raving
about it. I just personally like Firebird for many reasons and do not see
any reasons to use something else thus far. I've played with the embedded
version a little, but as I mentioned before, the server is super easy to
deploy and it makes scaling up a customer's installation just as easy.

Warm Regards,

Lee