B4J Question Return inside Try Catch

[aeric]

Refer to previous thread:

How to handle unclosed query, resultset & trsancsaction when database connection is broken?

Hi guys, In a non UI database, I have a codes like these Sub Process_Globals Private pool As ConnectionPool Private Tm As Timer End Sub Sub AppStart (Args() As String) pool.Initialize(....) Tm.Initialize("TM",3000) Tm.Enabled = True Try...

www.b4x.com

Dim sql As SQL = pool.GetConnection
Try
 'work with sql
 
 If some_condition = True Then
  Return
 End If
 
Catch
 'handle failure
End Try
sql.Close

If the code exit from "Return", does the code after "End Try" execute ? In the above example, sql.Close.

 

[emexes]

If the code exit from "Return", does the code after "End Try" execute ?

No.

But if you still really want to try this quantum duality approach to programming, you could use Sleep(0) instead of Return to harness the magic of resumable subs.

 

[aeric]

I want to make sure the sql connection is closed otherwise it will cause connection time out between the client and server.

 

[aeric]

Meaning everytime I need to close the connection before using Return?

Sub Foo
    Dim sql As SQL = pool.GetConnection
    Try 
        If some_condition = True Then
            sql.Close
            Return
       End If

      'work with sql 
    Catch
     'handle failure
    End Try
    sql.Close
End Sub

 

[OliverA]

Why not just do

Sub Foo
    Dim sql As SQL = pool.GetConnection
    Try
        If some_condition = False Then
            ‘Do your processing
                'work with sql
       End If

    Catch
     'handle failure
    End Try
    sql.Close
End Sub

No extra return needed that complicates everything

edit: fixed semantics of code
edit2: should not be on my phone

 

[aeric]

Why not just do

Sub Foo
    Dim sql As SQL = pool.GetConnection
    Try
        If some_condition = False Then
            ‘Do your processing
                'work with sql
       End If

      'work with sql
    Catch
     'handle failure
    End Try
    sql.Close
End Sub

No extra return needed that complicates everything

edit: fixed semantics of code

Ok, I will try to avoid using Return. I am converting my PHP script which use return; so I also use the same approach in B4J.

 

[OliverA]

Btw, you may want to move the getconnection into the try part. It will fail if there is an issue.

 

[aeric]

Btw, you may want to move the getconnection into the try part. It will fail if there is an issue.

Ok, I will experiment with it later. For the time being, everything seems working fine.