Thx for your answer Daniel. I'll give FB 1.5 a try then...

Henrik

-----Original Message-----
From: Daniel Rail [mailto:daniel@...]
Sent: 5. september 2003 19:26
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] "for select" and break

Hi,

At September 5, 2003, 13:38, Henrik Sitter wrote:

> Hello,

> I would like to do something like:

> for select aValue
> from aTable
> into aVariable
> do
> begin
> if (aVariable = anInputVariable) then
> break;
> end
> .
> .
> /* rest of code */
> .
> .

> The 'break' is not valid syntax, but is there a simple way to

accomplish

> this...to break out of a 'for select' loop?

For FB 1.0, you can use EXIT, but that will stop the execution of the
stored procedure.

The good news is that it is implemented in FB 1.5, which is at RC5
stage. There should be a RC6 before final release. But, I can tell you
that I don't have any problems using it in production at the moment.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)



To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/