[DUG] No boolean in firebird?

[AlanRose]

When I use Firebird I like to create my own Boolean type field.
F.i. in your sql creation script add a domain MYBOOL

CREATE DOMAIN MYBOOL AS
SMALLINT DEFAULT 0
CHECK (VALUE BETWEEN 0 AND 1);

Then you assign as per normal


CREATE TABLE MYTABLE(

    MYTABLEID  INTEGER NOT NULL,
    ABOOLFIELD MYBOOL, etc..etc






-----Original Message-----
From: delphi-bounces at delphi.org.nz [mailto:delphi-bounces at delphi.org.nz]
On Behalf Of Alister Christie
Sent: Tuesday, 12 June 2007 1:15 p.m.
To: NZ Borland Developers Group - Delphi List
Subject: [DUG] No boolean in firebird?

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?

-- 
Alister Christie
Computers for People
Ph: 04 471 1849 Fax: 04 471 1266
http://www.salespartner.co.nz
PO Box 13085
Johnsonville
Wellington 

_______________________________________________
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


-- 
No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.472 / Virus Database: 269.8.13/844 - Release Date:
6/11/2007 5:10 p.m.