Sub Example1
Wait For (CallSub2(Starter,"NonQueryAsync","CREATE TABLE testing (val1 nvarchar(5) NULL, val2 smallint NOT NULL)")) Complete (Success As Boolean)
Log("example1 success=" & Success)
End Sub
Sub Example2
Wait For (CallSub2(Starter,"NonQueryAsync","INSERT INTO testing val1,val2 VALUES ('A',1),('B',2),('C',3)")) Complete (Success As Boolean)
Log("example2 success=" & Success)
End Sub
Sub Example3
Wait For (CallSub2(Starter,"QueryAsync","SELECT * FROM testing")) Complete (Result As JdbcResultSet)
Dim row As String
Do While Result.NextRow
row = ""
For i = 0 To Result.ColumnCount - 1
row = Result.GetString2(i) & " "
Next
Log(row)
Loop
Result.Close
CallSub(Starter,"CloseConnection")
End Sub