Android Question RDC database field content to variable in B4A

Discussion in 'Android Questions' started by Jan Kanon PA7X, May 20, 2015.

  1. Jan Kanon PA7X

    Jan Kanon PA7X New Member Licensed User

    I am succesful working with RDC connected to a backend SQLserver 2012 database. I was wondering is there an easy way to transfer database field content to a variable in B4A. i.e.
    strEmpname = tableHREmployee.Field("Empname"). Now the results are put into the Log screen by Printable.

    Please if anyone has suggestions let me know

    Regards, Jan H Kanon
  2. DonManfred

    DonManfred Expert Licensed User

    Follow the RDC tutorial, get a RDC instance running and see the example.
    thedesolatesoul likes this.
  3. Jan Kanon PA7X

    Jan Kanon PA7X New Member Licensed User

    Hi Manfred,

    Thanks for your reaction, unfortunately I can only find the Tutorial of RDC in Spanish and the examples are as far as I can see not about retrieving database info into separate variables or did I miss something ?

    Regards, Jan
  4. DonManfred

    DonManfred Expert Licensed User


    See the Tutorial.

    And see the example-code in this tutorial...

    Sub JobDone(Job As HttpJob)
    If Job.Success = False Then
    Log("Error: " & Job.ErrorMessage)
    If Job.JobName = "DBRequest" Then
    Dim result As DBResult = reqManager.HandleJob(Job)
    If result.Tag = "cat 1" Then 'query tag
             For Each records() As Object In result.Rows
    Dim name As String = records(0'or records(result.Columns.Get("name"))
    End If
    End If
    End If
    End Sub
    thedesolatesoul likes this.