what is the best way to prevent divide by zero in procedures (beside if of course)

Article View: borland.public.interbase.sql

Article #219

Back to borland.public.interbase.sql Previous Next

#219

From: Isaac
Date: Sat, 14 Jun 2008 13:21

9 lines
1158 bytes

Hello,
It may sound stupid question but I have a very long stored procedure 
full of calculations so I had to test variables for null and 0 every 
time I need to make calculations I do so with many IFs

I wonder if there another way prevent divide  by zero error and keep my 
code clear and smaller

Thanks

Technical Details

Message-ID: <4853c54e@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!feeder.erje.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,33dff1ce947657c8,start
X-Google-Attributes: gid114a0e,domainid0,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Date: Sat, 14 Jun 2008 16:21:50 +0300
From: Isaac <no@no.com>
User-Agent: Thunderbird 2.0.0.14 (Windows/20080421)
MIME-Version: 1.0
Newsgroups: borland.public.interbase.sql
Subject: what is the best way to prevent divide by zero in procedures (beside
 if of course)
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 41.234.198.187
Message-ID: <4853c54e@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1213449550 41.234.198.187 (14 Jun 2008 06:19:10 -0700)
Lines: 9
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!feeder.erje.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail