Android Question [Solved] DEBUG ExecNonQuery2 with LOG()

[makis_best]

Hello

Is there any way to LOG() ExecNonQuery2?

For example something like

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

 

[rosippc64a]

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.

 

[makis_best]

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.

 

[Erel]

Yes:

Sub ExecNonQuery2(Query As String, Params As List)
 Log(Query)
 SQL.ExecNonQuery2(Query, Params)
End Sub

 

[makis_best]

Yes:

Sub ExecNonQuery2(Query As String, Params As List)
 Log(Query)
 SQL.ExecNonQuery2(Query, Params)
End Sub

@Erel You are God...

Thank you.