Android Question [Solved] DEBUG ExecNonQuery2 with LOG()

makis_best

Well-Known Member
Licensed User
Longtime User
Hello

Is there any way to LOG() ExecNonQuery2?

For example something like

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

rosippc64a

Active Member
Licensed User
Longtime 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:
Upvote 0

makis_best

Well-Known Member
Licensed User
Longtime 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.
 
Upvote 0
Top