Android Question Stored Procedure using jRDC2

[Chris Guanzon]

Hello everyone,

I need help on how to use stored procedure in B4A using jRDC2.

This is my code in B4A

Sub UserLogin As ResumableSub
    Try
        Dim req As DBRequestManager = CreateRequest
        Dim cmd As DBCommand = CreateCommand("pLogin", Array(EditText1.Text, EditText2.Text))
        Wait For (req.ExecuteQuery(cmd, 0, Null)) JobDone (j As HttpJob)
        If j.Success Then
            req.HandleJobAsync(j, "req")
            Wait For (req) req_Result (res As DBResult)
            'work with result
            req.PrintTable(res)
            If res.Rows.Size = 0 Then
                MsgboxAsync("Invalid user credentials, please try again", "Error")
                Wait For Msgbox_Result
                Return False
            Else
                For Each row() As Object In res.Rows
                    Variables.Name = row(res.Columns.Get("firstname")) & " " & row(res.Columns.Get("lastname"))
                Next
                Return True
            End If
        Else
            MsgboxAsync("Cannot connect to the server, please check your internet connection and try again.", "Error")
            Wait For Msgbox_Result
            Log("ERROR: " & j.ErrorMessage)
            Return False
        End If
        
        j.Release
    Catch
        MsgboxAsync("An error occurred, please try again later.", "Error")
        Wait For Msgbox_Result
        Log(LastException)
        Return False
    End Try
    
End Sub

and this is the code in .config file in jRDC2

sql.pLogin=CALL pLogin(?,?)

I don't know if this is the right way to do it. Is there a way to use it?

I've already search the forum but i can't find any that uses jRDC2.

 

[Erel]

jRDC2, MSSQL, StoredProcedure and Output Direction

Hello everybody, I have the following combination: B4A with jRDC2 MSSQL Server as Database Server I am working with stored procedures on the MSSQL Server. These are working with jRDC2 with no problems. But now I would like to realize to get an output parameter of the stored procedure. (Which...

www.b4x.com

 

[Chris Guanzon]

Where can i find the library here? https://www.b4x.com/android/forum/threads/calling-a-mysql-stored-procedure.51312/post-321351

 

[Erel]

It is the internal jSQL library. B4J. Not B4A.

 

[Chris Guanzon]

How can i add this to jRDC2? Sorry, i am not as good as others. I'm just a beginner using B4X.

 

[Erel]

First step is to create a new B4J project and write the code for calling a stored procedure. Adding it to jRDC2 will be simple.

 

[Chris Guanzon]

is this same with MySQL? Still can't figure out how to do it.

 

[Erel]

Yes

 

[Chris Guanzon]

Can you walk me through with this? If it's okay. I really don't have any idea on how to do it.

 

[Erel]

First start a new thread in B4J forum. Post the code that you are trying to run explain what happens.