B4J Question [SOLVED] JRDC2 MSSQL procedure return table

[makis_best]

Hi.

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?

Thank you.

 

[EnriqueGonzalez]

Jrdc2 is not planned for procedure calling. You could adjust it tho.

Read about procedures here:

SQL: Simplyfying Calling Stored Procedures

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

 

[OliverA]

The result of Scalc1 is a table

Please note that exec query can actually call simple stored procedures that return a result set (a table). No special magic needed.

 

[makis_best]

@OliverA I understand that is not a magic.
My problem is how from B4A I will pass the parameters to JRDC2 and get back my record set.

 

[OliverA]

My problem is how from B4A I will pass the parameters to JRDC2 and get back my record set.

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

sql.sLogin=CALL sLogin(?,?)

and in your code something like:

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

 

[makis_best]

So simple?
I will try it now and I be back.

 

[makis_best]

Yes...
@OliverA working like a beauty....