> Hello,
>
> I have the following two execute block calls:
>
> execute block
> as
> declare i Integer;
> begin
> i = 1;
> while (i <= 10) do
> begin
> execute procedure p_donothing;
> i = i + 1;
> end
> end
>
>
> and:
>
> execute block
> as
> declare i Integer;
> declare v Integer;
> begin
> i = 1;
> while (i <= 10) do
> begin
> select 1 from rdb$database into :v;
> i = i + 1;
> end
> end
>
>
> I do see EXECUTE BLOCK and the various sub P_DONOTHING calls in the
> trace output, but I don't see the individual SELECT 1 FROM ... calls in
> case of the second EXECUTE BLOCK statement.
>
> Is this as designed?
Yes. The whole PSQL block (except of calls of procedures, triggers and
dynamic
statements) is the single statement from the engine POV.
Regards,
Vlad
------------------------------------------------------------------------------
EditLive Enterprise is the world's most technically advanced content
authoring tool. Experience the power of Track Changes, Inline Image
Editing and ensure content is compliant with Accessibility Checking.
http://p.sf.net/sfu/ephox-dev2dev
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
