Filter by logic field

Article View: borland.public.vdbase.data.sql

Article #231

Back to borland.public.vdbase.data.sql Previous Next

#231

From: Alfredo Segovia
Date: Tue, 12 Jan 1999 00:00

18 lines
1003 bytes

I posted this message in the programing newsgroup, but after that I
realized this was the right place to do it.

I am trying to filter a table on a logical field. But found that
although this works,

select * form mytable where myfield(logic) = true

the following one only comes with no records:

select * form mytable where myfield = false

What am I doing wrong? Could anyone give some hints?

Thank you in advance

Alfredo Segovia
alfredo@ymg.urban.ne.jp

Technical Details

Message-ID: <369B7ECB.DCFA7C@ymg.urban.ne.jp>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,e8049caf4d5b1649,start
X-Google-Attributes: gidff5a1,public
From: Alfredo Segovia <alfredo@ymg.urban.ne.jp>
Subject: Filter by logic field
Date: 1999/01/12
Message-ID: <369B7ECB.DCFA7C@ymg.urban.ne.jp>
X-Deja-AN: 431738687
Content-Transfer-Encoding: 7bit
X-Accept-Language: ja,es-AR,es,en
Content-Type: text/plain; charset=iso-2022-jp
Organization: Another Netscape Collabra Server User
Mime-Version: 1.0
Newsgroups: borland.public.vdbase.data.sql