Article View: borland.public.vdbase.data.sql
Article #1275Re: sql and logical field
From: Tom Gleaton
Date: Sat, 28 Mar 1998 00:00
Date: Sat, 28 Mar 1998 00:00
18 lines
944 bytes
944 bytes
Ed Grant wrote > How can I filter an sql select with a logical field > Select * from customer.dbf where del = true You may be running into something I just learned this week. Logical fields in Vdb7 are Initilized to NULL not False as previous versions of db. Therefore you may not get the desired result with querry, unless you first initilize all logical fields to TRUE or FALSE. IE Use Customer replace all <myfield> with false -- Tom Gleaton County of Riverside, Riverside California
Technical Details
Message-ID:
<01bd5a7b$1a5383c0$344c96d1@dict2>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<6fjbgh$351$1@news2.digex.net>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: ff5a1,2b1eacab6e673c90 X-Google-Attributes: gidff5a1,public From: "Tom Gleaton" <tgleaton@linkline.com> Subject: Re: sql and logical field Date: 1998/03/28 Message-ID: <01bd5a7b$1a5383c0$344c96d1@dict2> X-Deja-AN: 338631181 References: <6fjbgh$351$1@news2.digex.net> Organization: Another Netscape Collabra Server User Newsgroups: borland.public.vdbase.data.sql