Erel thank you for your answer
Is it possible to capture the log error as a string.
I can create a sub that would write this string to a table in the mssql
something like this
Sub slog (sqlstr As String)
If xlog<> 1 Then Return
Dim cursor As JdbcResultSet
Dim xsql As String
xsql = "update Z_SETUP set xsql='" & sqlstr & "' where id=1"
Log(xsql)
Main.sqlall.ExecNonQuery(xsql)
End Sub