Empty field in sql query

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

Article #1090

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

#1090

From: Francesco Rossi
Date: Wed, 29 Apr 1998 00:00

14 lines
950 bytes

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.
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 ?

Thank.

Technical Details

Message-ID: <01bd73a9$f0659ba0$12f3f3c2@pserver>

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

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,bbdcd10171d882f5,start
X-Google-Attributes: gidff5a1,public
From: "Francesco Rossi" <mario@mbox.medianetis.it>
Subject: Empty field in sql query
Date: 1998/04/29
Message-ID: <01bd73a9$f0659ba0$12f3f3c2@pserver>
X-Deja-AN: 348836656
Organization: R.S.I. di Francesco Rossi
Newsgroups: borland.public.vdbase.data.sql