Article View: borland.public.vdbase.data.sql
Article #1094Re: Empty field in sql query
From: hirschv at mindspring dot com Ke...
Date: Thu, 30 Apr 1998 00:00
Date: Thu, 30 Apr 1998 00:00
21 lines
1041 bytes
1041 bytes
"Francesco Rossi" <mario@mbox.medianetis.it> wrote:
>How can i do for generate sql query that in place of empty return zero for
>numeric field ?
Probably do something like:
if form......["fields"].value == null
nValue = 0
else
nValue = form....["fields"].value
endif
// calculate using nValue
This would be done in the canRender event for the text control ...
Ken
---
Ken Mayer (Golden Stag Productions)
http://www.mindspring.com/~hirschv/homepage.htm
Please respond in the newsgroup unless explictly asked otherwise
Technical Details
Message-ID:
<3547ceab.2611016@forums.borland.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<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: hirschv at mindspring dot com (Ken Mayer ) Subject: Re: Empty field in sql query Date: 1998/04/30 Message-ID: <3547ceab.2611016@forums.borland.com> X-Deja-AN: 348923896 References: <01bd73a9$f0659ba0$12f3f3c2@pserver> Reply-To: hirschv@nospam.mindspring.com Organization: Golden Stag Productions Newsgroups: borland.public.vdbase.data.sql