Re: BOOLEAN

Article View: borland.public.interbase.sql

Article #11170

Back to borland.public.interbase.sql Previous Next

#11170

From: Woody (TMW)
Date: Fri, 06 Dec 2002 18:03

18 lines
1563 bytes

"T Fehr" <nospam@eliaswoodwork.com> wrote in message
news:3df0af6c$1@newsgroups.borland.com...
> Use a Char(1) field and put a check constraint on it so it will only allow
> either a 'T' or 'F'.  You can also define it as NOT NULL and set the
DEFAULT
> to 'F'.  If you decide to create a DOMAIN for it don't call it BOOLEAN (I
> use LOGICAL) or you will have problems migrating your database to newer
> versions of IB.
>

Also, make sure you define the true and false values for the TDBCheckbox
component.


--
Woody (TMW)

Drugs may lead to nowhere, but at least it's the scenic route.

Technical Details

Message-ID: <3df0e67a$2@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!news.maxwell.syr.edu!newsfeed.online.be!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <3df0a5bb@newsgroups.borland.com> <3df0af6c$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 114a0e,c7f065d637216af9
X-Google-Attributes: gid114a0e,public
X-Google-ArrivalTime: 2002-12-06 10:09:57 PST
From: "Woody \(TMW\)" <woody.tmw@ih2000.net>
Newsgroups: borland.public.interbase.sql
References: <3df0a5bb@newsgroups.borland.com> <3df0af6c$1@newsgroups.borland.com>
Subject: Re: BOOLEAN
Date: Fri, 6 Dec 2002 12:03:46 -0600
Lines: 20
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 209.34.97.205
Message-ID: <3df0e67a$2@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1039197818 209.34.97.205 (6 Dec 2002 10:03:38 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!news.maxwell.syr.edu!newsfeed.online.be!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message