Hi,

I wrote a script that creates some temporary tables. Since I don't know
if the tables exist or not, I embedded the code in a begin - exception -
end block.

During runtime that works fine, but in EDBManager an exception is raised
every time if the table already exists, even with "Stop on Exeptions"
set to false.

Is that the normal behaviour?

Regards Uli

Uli,

<< During runtime that works fine, but in EDBManager an exception is raised
every time if the table already exists, even with "Stop on Exeptions" set to
false. >>

Is the execution of the script actually stopping, or is it just reporting
the exception ?  It should always report the exception, but stop only if you
have Pause on Exceptions checked.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

> Is the execution of the script actually stopping, or is it just reporting
> the exception ?  It should always report the exception, but stop only if you
> have Pause on Exceptions checked.

It's not clear. In the status-bar it says "The scipt was executed
successfully..." On the gutter there is a Stop-icon, not the pause-icon.

I am creating 2 tables, thus the exception should be raised twice when
they exist. This is the case when "Pause on Exceptions" is checked. If
not, the exception is reported only for the second table.

I posted the sql into the binaries.

Regards Uli

Uli,

<< It's not clear. In the status-bar it says "The scipt was executed
successfully..." On the gutter there is a Stop-icon, not the pause-icon.

I am creating 2 tables, thus the exception should be raised twice when they
exist. This is the case when "Pause on Exceptions" is checked. If not, the
exception is reported only for the second table. >>

Okay, I see what you're saying now.  This is just the way that it was
designed, but I'll see if I can stop if from showing the last exception if
there is an EXCEPTION block in effect.

--
Tim Young
Elevate Software
www.elevatesoft.com