Re: show SP result set

Article View: borland.public.interbase.sql

Article #924

Back to borland.public.interbase.sql Previous Next

#924

From: Wayne Niddery [TeamB]
Date: Thu, 26 Apr 2007 14:02

19 lines
1900 bytes

aleplgr wrote:
> Hi! In a stored procedure I process a table and to show it to the end
> user now I  have to execute a SELECT at the client side,out of the
> SP, this SELECT shows the end user a 4 columns,500 rows table. 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.

Being able to select from a stored procedure is exactly the way to do this - 
Select is the SQL means of returning a result set. Simply executing a stored 
procedure can only return a single row of values.

Can you explain why you think you need to avoid calling select on the client 
side?

-- 
Wayne Niddery - Winwright, Inc (www.winwright.ca)
"The two most abundant elements in the universe are hydrogen and
stupidity." - Harlan Ellison

Technical Details

Message-ID: <4630b0e8$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!feeder3.cambrium.nl!feed.tweaknews.nl!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

References: <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
Reply-To: "Wayne Niddery [TeamB]" <wniddery@chaffaci.on.ca>
From: "Wayne Niddery [TeamB]" <wniddery@chaffaci.on.ca>
Newsgroups: borland.public.interbase.sql
References: <46306a55$1@newsgroups.borland.com>
Subject: Re: show SP result set
Date: Thu, 26 Apr 2007 10:02:16 -0400
Lines: 21
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 69.17.170.228
Message-ID: <4630b0e8$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1177596136 69.17.170.228 (26 Apr 2007 07:02:16 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!feeder3.cambrium.nl!feed.tweaknews.nl!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

Reply to Parent Message