Re: need help with stored procedure

Article View: borland.public.interbase.sql

Article #756

Back to borland.public.interbase.sql Previous Next

#756

From: Bill Todd
Date: Tue, 26 Jun 2007 15:33

19 lines
1363 bytes

Since the SELECT in the stored procedure includes a GROUP BY clause I
assume it returns more than one record. Therefore you need to use

FOR SELECT...

DO
  SUSPEND;

This will convert the stored proc to a selectable stored proc and let
you retrive all of the rows in the result set. To call the modified
stored procedure use:

SELECT * FROM MAX_TRAFFIC(ADATE, GROUP_NO, MSC)

For more information read the section on stored procedures in the data
definition guide.

-- 
Bill Todd (TeamB)

Technical Details

Message-ID: <468131cd$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

References: <4680c695@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,220d4992ac1e09be
X-Google-Attributes: gid114a0e,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Bill Todd" <no@no.com>
Subject: Re: need help with stored procedure
Newsgroups: borland.public.interbase.sql
References:  <4680c695@newsgroups.borland.com>
Organization: The Database Group, Inc.
User-Agent: XanaNews/1.18.1.6
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
NNTP-Posting-Host: 216.207.211.19
Message-ID: <468131cd$1@newsgroups.borland.com>
Date: 26 Jun 2007 08:33:33 -0700
X-Trace: newsgroups.borland.com 1182872013 216.207.211.19 (26 Jun 2007 08:33:33 -0700)
Lines: 19
X-Authenticated-User: btodd
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Reply to Parent Message