Re: Getting out of a For Select

Article View: borland.public.interbase.sql

Article #11404

Back to borland.public.interbase.sql Previous Next

#11404

From: Bojidar Alexandrov
Date: Tue, 26 Nov 2002 14:02

22 lines
1548 bytes

Jose Carlos wrote:
> Hi all,
>
>   I have a select in a  stored procedure that can return multiple
> records but I only need to get the first one. How can I do it ?
>   I haven't found a way to get out of a "for select" and continue
> executing mystored procedure. I cannot use a group y clause nor
> functions like min, max.
>   I am using Interbase 6.0.2 with Win2k.
>
>   Thanks for reading.
>
> Juliano

There is break but don't use it.
Try with wile loop instead or separate sp with exit after the first suspend


--
Bojidar Alexanrov
Kodar Ltd.
http://www.Kodar.net

Technical Details

Message-ID: <3de37f15@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-05!sn-xit-01!sn-xit-04!supernews.com!newshosting.com!news-xfer1.atl.newshosting.com!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

References: <3de379e0@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 114a0e,347cf761cb64a319
X-Google-Attributes: gid114a0e,public
X-Google-ArrivalTime: 2002-11-26 06:06:05 PST
From: "Bojidar Alexandrov" <bojo@kodar.net>
Newsgroups: borland.public.interbase.sql
References: <3de379e0@newsgroups.borland.com>
Subject: Re: Getting out of a For Select
Date: Tue, 26 Nov 2002 16:02:58 +0200
Lines: 24
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4920.2300
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4920.2300
NNTP-Posting-Host: 213.169.35.65
Message-ID: <3de37f15@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1038319381 213.169.35.65 (26 Nov 2002 06:03:01 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-05!sn-xit-01!sn-xit-04!supernews.com!newshosting.com!news-xfer1.atl.newshosting.com!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Reply to Parent Message