Android Question How to operate the database after JRDC2 connection

[K_Kai]

Hi：
I followed the tutorial to learn this post，（MSSQL）

Remote Database Connector (RDC) - Connect to any remote DB

jRDC version 2 is available here: https://www.b4x.com/android/forum/t...ation-of-rdc-remote-database-connector.61801/

www.b4x.com

And it succeeded，thanks a lot

But The result is output in log,I don’t know how to display it to the app
if i have db like this，（id is incremented）

if My app：

read, Update，delete，addnew with id
How to divide the above into multiple buttons
Please teach me again and I will study further
thanks again

 

[K_Kai]

with search :i want If no data is found,then msgbox"Can't found"

 

[Erel]

Why are you following a very old tutorial where the first line says: jRDC version 2 is available here: https://www.b4x.com/android/forum/t...ation-of-rdc-remote-database-connector.61801/

 

[K_Kai]

yes，erel
I used JRDC2
But I can't find the output call ?

 

[Erel]

You can use B4XTable or FlexibleTable to show a table.

 

[aeric]

The result is output in log,I don’t know how to display it to the app

Use the new JRDC2 as told by Erel then change the GetAnimal sub to something like this:

Sub GetAnimal(id As Int)
    Dim req As DBRequestManager = CreateRequest
    Dim cmd As DBCommand = CreateCommand("select_app", Array(id))
    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)
        'For Each row() As Object In res.Rows
        '    EditText2.Text = row(res.Columns.Get("name"))          
        '    EditText3.Text = row(res.Columns.Get("kg"))
        'Next
        Dim row() As Object = res.Rows.Get(0)
        EditText2.Text = row(res.Columns.Get("name"))
        EditText3.Text = row(res.Columns.Get("kg"))
    Else
        Log("ERROR: " & j.ErrorMessage)
    End If
    j.Release
End Sub

 

[K_Kai]

Use the new JRDC2 as told by Erel then change the GetAnimal sub to something like this:

Sub GetAnimal(id As Int)
    Dim req As DBRequestManager = CreateRequest
    Dim cmd As DBCommand = CreateCommand("select_app", Array(id))
    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)
        'For Each row() As Object In res.Rows
        '    EditText2.Text = row(res.Columns.Get("name"))         
        '    EditText3.Text = row(res.Columns.Get("kg"))
        'Next
        Dim row() As Object = res.Rows.Get(0)
        EditText2.Text = row(res.Columns.Get("name"))
        EditText3.Text = row(res.Columns.Get("kg"))
    Else
        Log("ERROR: " & j.ErrorMessage)
    End If
    j.Release
End Sub

[/引用]

Hi thank you
You know me
but have some Report an error

I'm use MSSsql ，Not mysql，Is it related to this？
How to change
please

 

[K_Kai]

error:
Unrecognized class member: HandleJobAsync

 

[aeric]

HandleJobAsync is inside DBRequestManager.bas
Are you using JRDC2 from [B4X] jRDC2 - B4J implementation of RDC (Remote Database Connector) ?

 

[K_Kai]

HandleJobAsync is inside DBRequestManager.bas
Are you using JRDC2 from [B4X] jRDC2 - B4J implementation of RDC (Remote Database Connector) ?

Yes,I make a mistake ，I relearned “ JRDC2-B4J”，
and now，It's successful ,Thank you very very much！

But there is no update process in the example ，I tried to write it by myself,But i'm failed again

in config.properties:

sql.update_app=update app set kg=? where id=？

Sub UpdateRecord(kg As String,id As Int)
    Dim cmd As DBCommand = CreateCommand("update_app", Array(kg,id))
    Dim j As HttpJob = CreateRequest.ExecuteBatch(Array(cmd), Null)
    Wait For(j) JobDone(j As HttpJob)
    If j.Success Then
        Log("Inserted successfully!")
    Else
        Log("error:" & j.ErrorMessage)
    End If
    j.Release
End Sub
Sub Button2_Click
    UpdateRecord(EditText3.Text,EditText1.Text )
End Sub

 

[Erel]

We cannot help you if you:
1. Ignore our answers.
2. Doesn't post enough information.

Start a new thread and include more information.