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?

Thanks!


Regards,
Thomas

------------------------------------------------------------------------------
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

Reply via email to