Syntax says they are different...virtual tables don't have the same flexibility apparently...I suppose you're looking for "why" though? http://www.sqlite.org/lang_createvtab.html Michael D. Black Senior Scientist Northrop Grumman Mission Systems
________________________________ From: sqlite-users-boun...@sqlite.org on behalf of Matt Young Sent: Tue 5/11/2010 1:50 PM To: General Discussion of SQLite Database Subject: [sqlite] create virtual table if not exists table_id??? sqlite> create virtual table if not exists words using fts3 (f1 ); Error: near "not": syntax error sqlite> create table if not exists U (w1 ); sqlite> Different syntax? virtual tables don't persist? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
