On 31 Jan 2011, at 1:24pm, Samuel Adam wrote: > On Mon, 31 Jan 2011 07:27:23 -0500, Simon Slavin <[email protected]> > wrote: > >> On 31 Jan 2011, at 11:30am, Gabe da Silveira wrote: >>> >>> CREATE VIRTUAL TABLE Directors USING fts3(id INTEGER PRIMARY KEY NOT >>> NULL, first_name TEXT NOT NULL, last_name TEXT NOT NULL, >>> show_last_name_first INTEGER DEFAULT 0, normalised_name TEXT NOT NULL, >>> sort_name TEXT NOT NULL, fanships_count INTEGER, image_url >>> VARCHAR(255)); [snip] >> >> Very strange. Naturally, the form where you need the quotes is wrong. >> You have explicitly defined 'id' as an INTEGER. > > Actually since this is an FTS3 table, the form with the quotes is the > correct one. As Mr. da Silveira alluded later in his post, in FTS3, the > row ID and only the row ID is an INTEGER
But from his CREATE command, isn't the column called 'id' an alias to the rowid ? But what I did miss is that these are VIRTUAL tables, not real ones. And therefore you cannot test the contents of the table by opening the database with the command-line tool. Would it be possible to temporarily remove the word 'VIRTUAL' from the CREATE command ? Would the rest of the application stop working ? If this does work, then the contents of the table can be tested as I outlined earlier. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
