On 30 Jul 2009, at 11:12am, Robert Villanoa wrote: > I am new to SQLite, and I have a question: In SQLite, is there a > statement apart from SELECT statement that can return a result set? > Or the SELECT statement is the only statement that can return a > result set
PRAGMA will, but only for some arguments. For instance, PRAGMA table_info(myTable) will. I think it's safe to treat all SELECT and PRAGMA statements as returning a result set, and no others. But there are probably some I've forgotten. And, of course, a badly formed SELECT statement, or one that refers to a column that doesn't exist, won't. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
