Re: debug stored procedures

Article View: borland.public.interbase.sql

Article #329

Back to borland.public.interbase.sql Previous Next

#329

From: Quinn Wildman (CodeGear Develope...
Date: Tue, 20 May 2008 16:27

17 lines
1413 bytes

Note that per SQL Standard,

NULL + anything = NULL
NULL - anything = NULL
NULL * anything = NULL
NULL / anything = NULL

Isaac wrote:
> 
> another question please,
> why when I sum a value with a variable hold a null value the result 
> evaluate to null not the first value ??
> 
> this mess a lot with my calculations when a select return <null> all my 
> calculation evaluate also to null how I can avoid this ???
> 
> Thanks

Technical Details

Message-ID: <4832fc3b@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder.news-service.com!news.isoc.lu!newsgroups.borland.com!not-for-mail

References: <4831f162@newsgroups.borland.com> <4831f280@newsgroups.borland.com> <4831f42a@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,8feff649be448d0
X-Google-Attributes: gid114a0e,domainid0,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Date: Tue, 20 May 2008 09:27:41 -0700
From: "Quinn Wildman (CodeGear Developer Support)" <qwildman@nospam.codegear.com>
User-Agent: Thunderbird 1.5.0.14 (Windows/20071210)
MIME-Version: 1.0
Newsgroups: borland.public.interbase.sql
Subject: Re: debug stored procedures
References: <4831f162@newsgroups.borland.com> <4831f280@newsgroups.borland.com> <4831f42a@newsgroups.borland.com>
In-Reply-To: <4831f42a@newsgroups.borland.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 10.143.100.209
Message-ID: <4832fc3b@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1211300923 10.143.100.209 (20 May 2008 09:28:43 -0700)
Lines: 17
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder.news-service.com!news.isoc.lu!newsgroups.borland.com!not-for-mail

Reply to Parent Message