B4J Question Return inside Try Catch

aeric

Expert
Licensed User
Longtime User
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

Erel said:
B4X: 
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
Click to expand...

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

emexes

Expert
Licensed User
aeric said:
If the code exit from "Return", does the code after "End Try" execute ?
Click to expand...
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.
 
Upvote 0

aeric

Expert
Licensed User
Longtime User
Meaning everytime I need to close the connection before using Return?

B4X: 
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
 
Upvote 0

OliverA

Expert
Licensed User
Longtime User
Why not just do
B4X: 
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
 
Upvote 0

aeric

Expert
Licensed User
Longtime User
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.
 
Upvote 0

OliverA

Expert
Licensed User
Longtime User
Btw, you may want to move the getconnection into the try part. It will fail if there is an issue.
 
Upvote 0
You must log in or register to reply here.
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…