Re: [sqlite] Statements that return a result set?

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@xxxxxxxxxx
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users