On Wed, 13 Feb 2008 17:45:20 +1100 BareFeet <[EMAIL PROTECTED]> dijo:
> > DELETE FROM worktable > > That is correct. You need a trailing semicolon though, on any command, > ie: > > delete from workTable; > > > But that just throws error messages. I tried adding the trailing semicolon: DELETE FROM worktable; But when I click on the green checkmark (in Kexi) I get: *The query is incorrect Syntax Error near "DELETE" Curiously, this works: SELECT * FROM worktable And without a trailing semicolon, too. I only went to SQL statements because the query builder GUI in Kexi did not give any way to delete rows. Now I'm beginning to wonder if the Kexi folks forgot to include a DELETE statement in their syntax. Thanks for the suggestions. Further ideas welcome. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
