revdb error: MUST be select SQL

Ivan ivan at internet-marketing-today.com
Sun May 7 23:23:51 EDT 2006


Hello,

I have been testing the revDataFromQuery function with a SQL pragma query for 
sqlite3: PRAGMA table_info("articles")

However, whenever I run it, I get an error message:

"revdberr,Database Error: MUST be select SQL!"


The reason seems to be because PRAGMA is not a select statement?

I have not been able to find a solution in the docs - would anyone be able to 
help me on this please?


thanks,
Ivan Wong
Internet-Marketing-Today.com




More information about the use-livecode mailing list