Good day,
I have a MSSQL Server and I created a stored procedure which is executed from another program (in VB.NET) and receives one parameter from the same program. Now I want to call the same stored procedure from B4J, sending that parameter as well. I used the following code but it gives me an error: "java.sql.SQLException: The executeQuery method must return a result set."
What am I doing wrong?
Thank you
I have a MSSQL Server and I created a stored procedure which is executed from another program (in VB.NET) and receives one parameter from the same program. Now I want to call the same stored procedure from B4J, sending that parameter as well. I used the following code but it gives me an error: "java.sql.SQLException: The executeQuery method must return a result set."
B4X:
Dim cs As Object = sql1.CreateCallStatement("{call uspAssignNewNumber(?)}", Array(RemarkData.Get(0)))
Dim rs As ResultSet = sql1.ExecCall(cs)What am I doing wrong?
Thank you