Sascha,
On 15 may 2004, at 10:48, Sascha Kuehn wrote:
here is my selectstatement: "SELECT * FROM WorkBook WHERE name LIKE '%page%'"
the workbook table contains several rows where "name" contains "pageup" and i want to get only this rows. but the selectstatement doesn't work. can somebody help me?
I don't see anything wrong with the query.
Check for the following:
1) Does the table WorkBook exist?
2) If so, does the column exist?
3) If so, are you sure there a rows where the column 'name' contain 'page'?
Check what sqlite_get_table() reports: what's the result code? Any errors in the error message string?
Regards,
-- Tito
