Re: sql and logical field

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

Article #1276

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

#1276

From: Ed Grant
Date: Sat, 28 Mar 1998 00:00

24 lines
1159 bytes

I'm use vdb 5.6 dbf's, and the logical fields should still be .t. or .f.


Tom Gleaton wrote in message <01bd5a7b$1a5383c0$344c96d1@dict2>...
>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: <6fjkkn$5vg$1@news2.digex.net>

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

References: <6fjbgh$351$1@news2.digex.net> <01bd5a7b$1a5383c0$344c96d1@dict2>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,2b1eacab6e673c90
X-Google-Attributes: gidff5a1,public
From: "Ed Grant" <ejg@digex.net>
Subject: Re: sql and logical field
Date: 1998/03/28
Message-ID: <6fjkkn$5vg$1@news2.digex.net>
X-Deja-AN: 338642411
References: <6fjbgh$351$1@news2.digex.net> <01bd5a7b$1a5383c0$344c96d1@dict2>
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Organization: DIGEX, Inc.
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message