Hello,
I'm new in dealing with B4A. To get experience I'm trying some Examples.
For now I'm dealing with RDC und access to Mysql.
MySQL and RDC are up und running well.
I'd like to read some rows from a Mysql-table.
But, if i try to the following statement from config.properties
with this B4A code
I'm getting no result:
If I use
then it works, like expected.
What am i doing wrong?
Fred
I'm new in dealing with B4A. To get experience I'm trying some Examples.
For now I'm dealing with RDC und access to Mysql.
MySQL and RDC are up und running well.
I'd like to read some rows from a Mysql-table.
But, if i try to the following statement from config.properties
B4X:
sql.select_personal=SELECT persnr, sname FROM t_personal WHERE persnr = ?
B4X:
Sub GetPerson(Nummer As String)
Dim cmd As DBCommand
cmd.Initialize
cmd.Name = "select_personal"
cmd.Parameters = Array As Object("29")
reqManager.ExecuteQuery(cmd, 0, "GetPerson")
Log ("Nummer " & Nummer )
End SubI'm getting no result:
B4X:
Tag: GetPerson, Columns: 2, Rows: 0
persnr snameIf I use
B4X:
sql.select_personal=SELECT persnr, sname FROM t_personal WHERE persnr = 29
B4X:
Tag: GetPerson, Columns: 2, Rows: 1
persnr sname
29 Krumenau HeinzWhat am i doing wrong?
Fred