Android Question [Solved] DEBUG ExecNonQuery2 with LOG()

Discussion in 'Android Questions' started by makis_best, Jun 14, 2019 at 7:17 PM.

  1. makis_best

    makis_best Member Licensed User

    Hello

    Is there any way to LOG() ExecNonQuery2?

    For example something like

    Code:
    SQL.ExecNonQuery2($"Update LOCALIItem Set Code = ?, Description = ? , Array As Object(Crsr.GetString("ValidCode"), Crsr.GetString("ValidDescription")))
    LOG(ExecNonQuery2)
    So I can see Update SQL Script executed.

    Thank you
     
    Last edited: Jun 14, 2019 at 7:28 PM
  2. rosippc64a

    rosippc64a Active Member Licensed User

    The code is wrong at a first look, there is an unfinished $". If I want to log my sql exec - I use sqlite database - I copy the database to my windows PC and use the sqlitestudio program do debug the sql statements. I inspect all variables value involved in statements and try execeute in sqlitestudio.
     
    Last edited: Jun 15, 2019 at 5:43 PM
  3. makis_best

    makis_best Member Licensed User

    For the moment I don't care if ExecNonQuery2 syntax is correct....
    I just care about the result.....
    If I can have the SQL Code generated.
     
  4. Erel

    Erel Administrator Staff Member Licensed User

    Yes:
    Code:
    Sub ExecNonQuery2(Query As String, Params As List)
     
    Log(Query)
     
    SQL.ExecNonQuery2(Query, Params)
    End Sub
     
    Peter Simpson likes this.
  5. makis_best

    makis_best Member Licensed User

    @Erel You are God...

    Thank you.
     
Loading...
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice