I am an absolute DUMMY when it comes to "networking". We are using Syspro and I am trying to connect to it via B4J code but just don't get it right (no problem via ODBC connection or making use of "Launch Power Query Editor" that is available under Excel -> Get Data -> Launch Power Query Editor...
Hi,
I am able to connect at Oracle DB with success. But how do I call both the procedure SQL_Success from button1_Click() event.
Here is my test code
B4X:
Public Sub SQL_Connect
sql.InitializeAsync("Oracle", "oracle.jdbc.driver.OracleDriver", $"jdbc:oracle:thin:@${dbsrv}:1521:mmjdb"$, dbusername, dbpwd)
End Sub
Private Sub SQL_Success(Success As Boolean)
If Success Then
Log("Connected Successfully")
Dim rs As ResultSet
rs=sql.ExecQuery("select table_name from user_tables")
Do While rs.NextRow
Log(rs.GetString2(0))
Loop
rs.Close
sql.Close
End If
End Sub