Hello!
I'm using b4xtable in my multiplaform APP to save some data following the Erel example "https://www.b4x.com/android/forum/t...ditable-b4xtable-form-example.104766/#content".
In this moment I need to put in the text of a some labels (label1.text) the data of some columns related a specific row, from the specific Query, but I'dont know wich are the sentence to make it possible.
I need some like CURSOR that works in B4A that returns the complet field using firstly the query :
Cursor1 = SQL1.ExecQuery("SELECT * FROM persons WHERE ID = " & ID)
and then, put this reults inside a labels:
label1.Text = Cursor1.GetString("FirstName")
label2.Text = Cursor1.GetString("LastName")
label3.Text = Cursor1.GetString("City")
label4.Text = Cursor1.Getint("Age")
.
.
.
I appreciate any clue to use some thing similar that works in multiplatform
I'm using b4xtable in my multiplaform APP to save some data following the Erel example "https://www.b4x.com/android/forum/t...ditable-b4xtable-form-example.104766/#content".
In this moment I need to put in the text of a some labels (label1.text) the data of some columns related a specific row, from the specific Query, but I'dont know wich are the sentence to make it possible.
I need some like CURSOR that works in B4A that returns the complet field using firstly the query :
Cursor1 = SQL1.ExecQuery("SELECT * FROM persons WHERE ID = " & ID)
and then, put this reults inside a labels:
label1.Text = Cursor1.GetString("FirstName")
label2.Text = Cursor1.GetString("LastName")
label3.Text = Cursor1.GetString("City")
label4.Text = Cursor1.Getint("Age")
.
.
.
I appreciate any clue to use some thing similar that works in multiplatform
Last edited: