Android Question DBUtils, why the IDE warns for an unreachable code ?

[Laurent95]

Hello,

Edit : It's not really due to DBUtils i think, but i want to use a modified DBUtils module in my code, that's why i put this title.

I have an interrogate.
I get a Warrning # 1 (Unreachable code detected) in the IDE when i uses this code

Sub TestWarning1(SQL As SQL) As String
    SQL.BeginTransaction
    Try
        'Do anything you want
        SQL.TransactionSuccessful
        Return "Ok"
    Catch
        Return LastException.Message
    End Try
    SQL.EndTransaction

But in example given by SQL Library, it's exactly like that it's showed how to use Begin/EndTransaction.

I know i can ignore the warning, but if someone can tell me why ?
Thanks.

Laurent.

 

[DonManfred]

but if someone can tell me why ?

You are calling

SQL.EndTransaction

at the end of your sub. BUT you are using return statements...

SQL.EndTransaction

will never be called in your code. You should place the EndTransaction in the line just before the return "OK"...

 

[Laurent95]

BUT you are using return statements...

SQL.EndTransaction

will never be called in your code. You should place the EndTransaction in the line just before the return "OK"...

Thank you so much Manfred for the quick reply

That's evident, when i wrote the code i focused on another warning #2 (Not all code paths return a value), i think that's why i did this mistake .

Mmmmmm, it seems sometime i will do better to do a little nap , already that i have difficulty to sleep actually .
.