Re: Empty field in sql query

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

Article #1095

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

#1095

From: Romain Strieff [TeamB]
Date: Thu, 30 Apr 1998 00:00

26 lines
1415 bytes

In article <01bd73a9$f0659ba0$12f3f3c2@pserver>, mario@mbox.medianetis.it 
grudgingly admits...
> Hi,
> In VDB701 i have verified that if in numeric fields of a DBF table there is
> no value, generate an sql query make, for this numeric field, an _empty_
> field.
> Es.: SELECT MyNumeric FROM MyTable
> If this empty field is used for a calculation, (a summary, a subtraction or
> an assignement) the result of calculation is _empty_ too, and it is not
> visible if used in a text object.
-----
That's normal, 10+Unknown=Unknown.

> Es.: MyResult = MyNumeric (in this case MyResult is equal to _empty_)
> How can i do for generate sql query that in place of empty return zero for
> numeric field ?
------
Set the table to have 0 as default for that field.
 

-- 
Romain Strieff [TeamB]
Want quick help? Check previous Q and A at:
http://forumsearch.borland.com:88/ and TIs at
http://www.borland.com/VdBASE/vdbprod.html

Technical Details

Message-ID: <MPG.fb28e9fce712ffd98ac7c@forums.borland.com>

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

References: <01bd73a9$f0659ba0$12f3f3c2@pserver>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,bbdcd10171d882f5
X-Google-Attributes: gidff5a1,public
From: Romain@Do.not.reply.via.e-mail (Romain Strieff [TeamB])
Subject: Re: Empty field in sql query
Date: 1998/04/30
Message-ID: <MPG.fb28e9fce712ffd98ac7c@forums.borland.com>
X-Deja-AN: 349065903
References: <01bd73a9$f0659ba0$12f3f3c2@pserver>
Reply-To: teamb@opto-pps.com
Organization: TeamB
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message