Tuesday 15 June 2010

ios - SQLite alter table with result from select statement -


I am trying to execute this statement in the Mozilla sqlite add-on

  Change table (select tbl_name from Sqlite_master where rowid = 1) Add GUID varchar   

but it runs in error:

SQLiteManager: Possibility Syntax Error: Table Change (select tbl_name from sqlite_master) where queue = 1) add GUID varchar ["(": near syntax error) exception name: NS_ERROR_FAILURE exception message: returned component failure code Or: 0x80004005 (ns_ARROARROEER) [mozIStorageConnection.createStatement]

Statement: Select tbl_name from Sqlite_master where rowid = 1 works fine

No comments:

Post a Comment