Article View: borland.public.vdbase.data.sql
Article #1026Re: null = 0 ?
From: Sebastian Degenaar
Date: Tue, 02 Jun 1998 00:00
Date: Tue, 02 Jun 1998 00:00
23 lines
1276 bytes
1276 bytes
Thanks Bowen ! Yes is it is vital that I do get the 0's as well as it is part of one of the fields in the report (or sql) that is needed to do a sum of the whole row. You cannot do a agg function including a null field. Therefore it is vital that somehow I can get the null = to 0.00 Thanks ! Bowen Moursund < wrote in message <6kv2v9$kfr3@forums.borland.com>... >It depends upon whether you need 0's, or simply need to exclude the rows >with nulls. >If the latter (the simplest), you might set query.sql to something like: > > select * from THETABLE where THEFIELD is not null >____ >Bowen Moursund (TeamB) >bowenNOSPAM@nerds.com >http://lonestar.texas.net/~moursund/ >Try this help resource: > http://www.dejanews.com/home_ps.shtml >
Technical Details
Message-ID:
<6kviil$kfs7@forums.borland.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<6ktg5s$jaf1@forums.borland.com> <6kv2v9$kfr3@forums.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: ff5a1,e593e030585ee67d X-Google-Attributes: gidff5a1,public From: "Sebastian Degenaar" <sdegenaar@yahoo.com> Subject: Re: null = 0 ? Date: 1998/06/02 Message-ID: <6kviil$kfs7@forums.borland.com> X-Deja-AN: 358637102 References: <6ktg5s$jaf1@forums.borland.com> <6kv2v9$kfr3@forums.borland.com> X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3 Organization: Another Netscape Collabra Server User Newsgroups: borland.public.vdbase.data.sql