Article View: borland.public.interbase.sql
Article #322Re: debug stored procedures
From: Bill Todd [TeamB]
Date: Tue, 20 May 2008 13:02
Date: Tue, 20 May 2008 13:02
15 lines
1792 bytes
1792 bytes
Your last post in this thread is: "sql server has isnull() function but interbase did not has it , I really did not want to use alot of if to test for null I hope also not to us UDF!!" which I understood to mean that you are looking for a way to do what ISNULL does in Transact SQL. In my reply I provided the alternatives that are available in IB. Now you are telling us that COALESCE gave you an error but you do not show us the code that caused the error. No one here can read your mind. If you want help you must provide enough information. -- Bill Todd (TeamB)
Technical Details
Message-ID:
<4832cc01@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!eweka.nl!lightspeed.eweka.nl!194.134.4.14.MISMATCH!news2.euro.net!feeder.news-service.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<4831f162@newsgroups.borland.com> <4831f280@newsgroups.borland.com> <4831f42a@newsgroups.borland.com> <483201d3$1@newsgroups.borland.com> <48321ed5$1@newsgroups.borland.com> <4832c323@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
From: "Bill Todd [TeamB]" <no@no.com>
Subject: Re: debug stored procedures
Newsgroups: borland.public.interbase.sql
References: <4831f162@newsgroups.borland.com> <4831f280@newsgroups.borland.com> <4831f42a@newsgroups.borland.com> <483201d3$1@newsgroups.borland.com> <48321ed5$1@newsgroups.borland.com> <4832c323@newsgroups.borland.com>
Organization: The Database Group, Inc.
User-Agent: XanaNews/1.18.1.9
X-Face: ":yn4zt^A_dn>6~{YJmu^B\'4w)e:apPM\VC=Dvf&*tASxX9|BYczkFd$xr.$vNSZ[3Uobr p]c4\+\l){!WQI.$]veP({HLd;CDYH?iN
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 76.208.40.243
Message-ID: <4832cc01@newsgroups.borland.com>
Date: 20 May 2008 06:02:57 -0700
X-Trace: newsgroups.borland.com 1211288577 76.208.40.243 (20 May 2008 06:02:57 -0700)
Lines: 15
X-Authenticated-User: btodd
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!eweka.nl!lightspeed.eweka.nl!194.134.4.14.MISMATCH!news2.euro.net!feeder.news-service.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail