I have these scenario I try to solve.
B4A client.
B4J as JRDC2 server
MsSQL database.
On MsSQL Server database I have a procedure called Scalc1 and get two variables Date1 and TheGidIn.
The result of Scalc1 is a table.
The questions are...
What I need to write on config.properties so I can use the Scalc1 procedure?
What code I need to write on B4A so I can execute the procedure and pass the variables with the array?
Updated 2018-08-16. Please note there are breaking changes to the new version of the library (SQLCallPRoc Version 1-10.zip) so it will work correctly with the Microsoft JDBC Driver. The sample for MYSQL has changed and there is a new sample for MS SQL Server. See post #5 for why the change was...
www.b4x.com
You could use that library or overall implement its functionality in Jrdc2
The same as a regular query, via ? So, for example, let's say you have a stored procedure called sLogin that has username and password as parameters, then in config.properties set up
B4X:
sql.sLogin=CALL sLogin(?,?)
and in your code something like:
B4X:
Dim cmd As DBCommand = CreateCommand("sLogin", Array("John", "password"))
And process it via ExecuteQuery like you would any other query that you do via DBRequestManager