Re: Filter by logic field

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

Article #232

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

#232

From: Gary Gary White
Date: Tue, 12 Jan 1999 00:00

17 lines
875 bytes

On Tue, 12 Jan 1999 11:56:44 -0500, Alfredo Segovia wrote:

> the following one only comes with no records:
> 
> select * form mytable where myfield = false
> 
> What am I doing wrong? Could anyone give some hints?

Probably getting bit with NULL's.  Try:

select * from mytable where myfield <> true


Gary

Some dBASE Stuff at
http://www.AppTools.com/dbase

Technical Details

Message-ID: <369b9522.1068205@forums.borland.com>

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

References: <369B7ECB.DCFA7C@ymg.urban.ne.jp>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,e8049caf4d5b1649
X-Google-Attributes: gidff5a1,public
From: Gary (Gary White)
Subject: Re: Filter by logic field
Date: 1999/01/12
Message-ID: <369b9522.1068205@forums.borland.com>
X-Deja-AN: 431752768
Content-Transfer-Encoding: 7bit
References: <369B7ECB.DCFA7C@ymg.urban.ne.jp>
Content-Type: text/plain; charset=us-ascii
Organization: Just Me
Mime-Version: 1.0
Reply-To: Gary
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message