Hi,
I am trying to retrieve data from a database as described in Chapter.12 in the basic tutorial for programming with Xojo, by using method Populate, with following code:
Var sql As String
Var rs As RowSet
sql = "SELECT name, email "
sql = sql + "FROM addressbook "
If TextField1.Text <> “” Then
sql = sql + “WHERE LOWER(name) LIKE LOWER(’%” + _
SQLify(TextField1.Text) + "%’) "
sql = sql + “OR LOWER(email) LIKE LOWER(’%” + _
SQLify(TextField1.Text) + “%’) "
End If
sql = sql + “ORDER BY name”
Try
rs = MyDatabase.SelectSQL(sql)
EmailAddressBox.RemoveAllRows
While Not rs.AfterLastRow
EmailAddressBox.AddRow(rs.Column(“name”).StringValue)
EmailAddressBox.CellValueAt(EmailAddressBox.LastAddedRowIndex, 1) = _
rs.Column(“email”).StringValue
rs.MoveToNextRow
Wend
Catch error As DatabaseException
MessageBox(error.Message)
End Try
THE ERRORS ARE:
“This item does not exist” and “Syntax Error” for line 18
rs.Column(“email").StringValue
where “email” is highlighted.
Please for advice,
Thank you