B4J Question SQL Video sample program issue

[OliverA]

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

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]

Maybe parametrized?

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]

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