I’m using the jRDC2 modified server (jRDCv2_mod_release_20240727) to call a stored procedure with OUT parameters, but I’m getting a compile error in B4A:
I’m using the jRDC2 modified server (jRDCv2_mod_release_20240727) to call a stored procedure with OUT parameters, but I’m getting a compile error in B4A:
sql.save_milk_purchase = CALL SaveMilkPurchase(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Could you please clarify the exact client-side steps to call a stored procedure with OUT parameters using the 20240727 mod?
Could someone please share a complete, working example for this scenario?
B4A Version: 13.40
Parsing code. (0.48s)
Java Version: 19
Building folders structure. (0.14s)
Running custom action. (0.28s)
Compiling code. Error
Error compiling program.
Error description: Unknown member: handlecalljobasync
Error occurred on line: 123
req.HandleCallJobAsync(j, "req")
Word: handlecalljobasync
Unknown member: HandleCallJobAsync
I’m using the jRDC2 modified server (jRDCv2_mod_release_20240727) to call a stored procedure with OUT parameters, but I’m getting a compile error in B4A:
mm:
Public Sub ExecuteCall(Command As String, Parameters() As Object) As ResumableSub
Dim Answer As Map
Answer.Initialize
Dim req As DBRequestManager = CreateRequest
Dim cmd As DBCommand
cmd.Initialize
cmd.Name = Command
cmd.Parameters = Parameters
Wait For (req.ExecuteCall(cmd, 0, Null)) JobDone(j As HttpJob)
Answer.Put("Success", j.Success)
If j.Success Then
req.HandleCallJobAsync(j, "req") '<---------------------------Problem Here
Wait For (req) req_CallResult(resultSets As List, outParams As Map)
Answer.Put("ResultSets", resultSets)
Answer.Put("OutParams", outParams)
Else
Log("❌ ExecuteCall Error: " & j.ErrorMessage)
Answer.Put("ErrorMessage", j.ErrorMessage)
End If
j.Release
Return Answer
End Sub
sql.save_milk_purchase = CALL SaveMilkPurchase(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Could you please clarify the exact client-side steps to call a stored procedure with OUT parameters using the 20240727 mod?
Could someone please share a complete, working example for this scenario?
B4A Version: 13.40
Parsing code. (0.48s)
Java Version: 19
Building folders structure. (0.14s)
Running custom action. (0.28s)
Compiling code. Error
Error compiling program.
Error description: Unknown member: handlecalljobasync
Error occurred on line: 123
req.HandleCallJobAsync(j, "req")
Word: handlecalljobasync