Re: 260 crashes if no plan

Article View: borland.public.interbase.ibconsole

Article #63

Back to borland.public.interbase.ibconsole Previous Next

#63

From: Brent Rose
Date: Fri, 16 Nov 2007 04:56

17 lines
1725 bytes

I agree, Gelein, "execute procedure" with no "suspend" tends to be the 
better way to return a guaranteed single "row" of field(s)...

...but my example was just a "minimal cutdown" to demonstrate the issue.... 
I was really wanting to return multiple calculated rows and display them as 
a dataset (so my UDF idea wasn't going to help me too much!)

Another example I have is:

A stored procedure to calculate and return a dataset of public holidays for 
a given calendar year (Anniversary Days, Easter, Xmas etc etc) . It requires 
no table access, returns mutliple rows, and must have suspenders...

-- 
Brent Rose
Whats On Report
brent@whatson.co.nz

Technical Details

Message-ID: <473d22ea$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!proxad.net!feeder1-2.proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References:

<47376995@newsgroups.borland.com> <4738ccfb$1@newsgroups.borland.com> <473b5279@newsgroups.borland.com> <473b5eb1$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: f4565,d43ae017dafff62d
X-Google-Attributes: gidf4565,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Brent Rose" <brent@whatson.co.nz>
Newsgroups: borland.public.interbase.ibconsole
References: <47376995@newsgroups.borland.com> <4738ccfb$1@newsgroups.borland.com> <473b5279@newsgroups.borland.com> <473b5eb1$1@newsgroups.borland.com>
Subject: Re: 260 crashes if no plan
Date: Fri, 16 Nov 2007 17:56:35 +1300
Lines: 19
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 203.79.66.167
Message-ID: <473d22ea$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1195188970 203.79.66.167 (15 Nov 2007 20:56:10 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!proxad.net!feeder1-2.proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message