[DUG] No boolean in firebird?

Robert martin rob at wildsoft.co.nz
Wed Jun 13 10:18:49 NZST 2007


Agreed.  When moving to Firebird we changed all our booleans to T/F 
fields.  Just Create a tool that updates all your dfms. 

Moving from BDE to a relational database is a BIG step.  We use IBOjects 
which has BDE replacement components that is very good.  However you 
would have to leave paradox behind at that point.

BDE SUCKS big time.  Although I was AMAZED to read that CodeGear is 
developing a BDE like replacement for a future Delphi !!!!!!  I was 
stunned.  Obviously enough people still use the BDE to make this an 
attraction.

Rob Martin
Software Engineer

phone +64 03 377 0495
fax   +64 03 377 0496
web www.chreos.com

Wild Software Ltd



Rohit Gupta wrote:
> The best advice I can give you (one that I ignored) is to replace all 
> (or most) of the tables with tqueries.  The second bit of advice is to 
> not use the default transaction and ensure that you understand the 
> transactions as they are different to paradox.  This applies to 
> firebird and interbase.
>
> What you can do is to use a char field holding either Y/N or T/F.
>
> Alister Christie wrote:
>> I'm in the process of converting a significant application off 
>> BDE/Paradox to probably firebird.  I'm looking at methods for doing 
>> this in a semi-automated way.  I had thought a good interim step 
>> would be to get the application running on BDE/Firebird via the 
>> Interbase driver in the BDE.  I'm trying to do this in a way that the 
>> application can run on both paradox and interbase, but I have hit a 
>> problem with a number of paradox boolean fields.  Okay that's 
>> probably enough background...
>>
>> So my question is there a way to get a paradox/interbase field to map 
>> to a TBooleanField on a TTable?
>>
>
> -- 
> *Rohit Gupta*
> * B.E. Elec.   M.E.   Mem IEEE    Associate IEE*
> *Technical Manager*
> *Computer Fanatics Limited*
> ** 
> *Tel*     +64 9 4892280
> *Fax*    +64 9 4892290
> *Email  *rohit at cfl.co.nz <mailto:rohit at cfl.co.nz>**
> *Web    *www.cfl.co.nz <http://www.cfl.co.nz/>
>  
> ------------------------------------------------------------------------
> This email and any attachments contain information, which is 
> confidential and may be subject to legal privilege and copyright. If 
> you are not the intended recipient, you must not use, distribute or 
> copy this email or attachments. If you have received this in error, 
> please notify us immediately by return email and then delete this 
> email and any attachments.
> ------------------------------------------------------------------------
>
> _______________________________________________
> NZ Borland Developers Group - Delphi mailing list
> Post: delphi at delphi.org.nz
> Admin: http://delphi.org.nz/mailman/listinfo/delphi
> Unsubscribe: send an email to delphi-request at delphi.org.nz with Subject: unsubscribe


More information about the Delphi mailing list