Subject | Re: [IBO] Not an IBO, only a SQL Question |
---|---|
Author | hans@hoogstraat.ca |
Post date | 2001-04-22T22:29:34Z |
Maybe like this ?
==========================
declare varable Flag char;
begin
Flag := 'F';
for select whatever from table
where suchandsuch = soandso
into :whatever do
begin
if (Flag = 'F') then
begin
Flag := 'T';
suspend;
end
else
exit;
end
==============================================
Gerhard Schober wrote:
==========================
declare varable Flag char;
begin
Flag := 'F';
for select whatever from table
where suchandsuch = soandso
into :whatever do
begin
if (Flag = 'F') then
begin
Flag := 'T';
suspend;
end
else
exit;
end
==============================================
Gerhard Schober wrote:
>
> Hi all,
>
> I have a little problem with a SELECT statement inside
> a Stored Procedure.
>
> A SELECT statement is getting some values with INTO
> to some variable. Everything works fine, but if
> the result of the SELECT statement is more the 1 record,
> an SQL error "Multiple Row in singleton select" will appear.
>
> Is there an easy way to read only the first record from
> the result ? It doesn't matter if there will be more the one.
>
> Thanks
>
> Gerhard J. Schober
>
> --------------------------------------------------
> DevCon Engineering
> P.O.Box 179
> 9490 Vaduz
> Principality of Liechtenstein
> --------------------------------------------------
> Web: www.devcon.li
> EMail: gjschober@...
> --------------------------------------------------
> 4C6B 5D10 84C0 48FD CE80 9CA1 0C74 34EA FA6C 6965
> --------------------------------------------------
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/