Article View: borland.public.interbase.sql
Article #925Re: show SP result set
From: Bill Todd
Date: Thu, 26 Apr 2007 14:05
Date: Thu, 26 Apr 2007 14:05
21 lines
1449 bytes
1449 bytes
aleplgr wrote: > Is it possible to execute the SELECT in the SP? so that the end user > only runs the SP and it returns the result table without having to > run the SELECT after the execution of the stored procedure. Assuming you have written a selectable stored procedure of the form FOR SELECT... DO SUSPEND; then all you have to do on the client is SELECT * FROM STORED_PROC_NAME The SELECT both executes the stored proc and returns the results. -- Bill Todd (TeamB)
Technical Details
Message-ID:
<4630b1c3$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!news.motzarella.org!newsfeed.kamp.net!newsfeed.kamp.net!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<46306a55$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 114a0e,87ed5f859036b198
X-Google-Attributes: gid114a0e,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Bill Todd" <no@no.com>
Subject: Re: show SP result set
Newsgroups: borland.public.interbase.sql
References: <46306a55$1@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: <4630b1c3$1@newsgroups.borland.com>
Date: 26 Apr 2007 07:05:55 -0700
X-Trace: newsgroups.borland.com 1177596355 216.207.211.19 (26 Apr 2007 07:05:55 -0700)
Lines: 21
X-Authenticated-User: btodd
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!news.motzarella.org!newsfeed.kamp.net!newsfeed.kamp.net!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail