B4J Question SQL Video sample program issue

OliverA · Apr 4, 2018

Looks like there is an issue in the sample program included in the SQL video. These lines (34&36):

B4X:

Dim id As String = "k'm"

Dim rs As ResultSet = sql.ExecQuery2("SELECT name, birth, image FROM students WHERE id = " & id, Array As String(10))

Lead to this

java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (unrecognized token: "'m")

Line 36 is actually causing the error, but it's caused by the value set in line 34. Not sure what was supposed to happen here.

DonManfred · Apr 5, 2018

Maybe parametrized?

B4X:

Dim rs As ResultSet = sql.ExecQuery2("SELECT name, birth, image FROM students WHERE id = ?", Array As String(id))

Note that you did used Parametrized query but your are not using the parameter.

Erel · Apr 5, 2018

It was a leftover from the "don't do" section. I will update the correct code.

Privacy & Transparency