SqlDbx Forum

FabricioAraujo

Member

Block match highlight fail with an BEGIN TRAN command exists

I found block match highlight very useful on longish stored procedures, since I can detect missed ends on nested blocks.

Today, I discovered the folowing: when I write a block (BEGIN..END) and in the middle of that block exists an BEGIN TRANSACTION  instruction - the highlighter simply get nuts and link my block begin not with the correct END but with next one.

if (blablabla)
begin
    select 1 from sys.objects
   rollback
    -- logging  code
    begin transaction
        ... logging error ...
    commit transaction
end
end --- procedure

SQLDbx 3.42 Personal Test version.
Put the cursor on the begin of the if and see what end it will take.

sqldbxhelp

Administrator

Re: Block match highlight fail with an BEGIN TRAN command exists

Thank you. Will be fixed in a next release