Re: return only first row

Article View: borland.public.interbase.sql

Article #231

Back to borland.public.interbase.sql Previous Next

#231

From: Isaac
Date: Sun, 15 Jun 2008 12:26

25 lines
1755 bytes

Wayne Niddery (TeamB) wrote:
>
> You can tell a select statement to only return 1 row (or any number 
> you want):
>
> select * from sometable
> order by whatever
> rows 1
>
> But to make a stored procedure *selectable* you must call Suspend 
> anyway. I.e. Suspend is what lets you do:
>
>  select * from myprocedure
>
> as though the procedure was a table.
>
> So it's just as easy to continue using For Select, but use the Rows 
> clause.
>
> You could just select (without For) into your return variables, as 
> long as you specify Rows 1, and not call Suspend, but then you 
> properly need to "execute procedure myprocedure" instead of selecting 
> from it.
>
yes I am not selecting from it any way, *Many Thanks*

Technical Details

Message-ID: <485509e6@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news1.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newspeer1.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

References: <485439ea@newsgroups.borland.com> <485474b1$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,28a1978876c492d6
X-Google-Attributes: gid114a0e,domainid0,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Date: Sun, 15 Jun 2008 15:26:59 +0300
From: Isaac <no@no.com>
User-Agent: Thunderbird 2.0.0.14 (Windows/20080421)
MIME-Version: 1.0
Newsgroups: borland.public.interbase.sql
Subject: Re: return only first row
References: <485439ea@newsgroups.borland.com> <485474b1$1@newsgroups.borland.com>
In-Reply-To: <485474b1$1@newsgroups.borland.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 41.234.199.226
Message-ID: <485509e6@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1213532646 41.234.199.226 (15 Jun 2008 05:24:06 -0700)
Lines: 25
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news1.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newspeer1.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail
X-Original-Bytes: 1571

Reply to Parent Message