Actually, that syntax in my question was just me being sloppy when asking the question. Sorry. The statement I'm issuing to the database via Adobe's libraries is
PRAGMA case_sensitive_like =1 But I take it from your answer that SQLite has no problem with this and that it is Adobe who are preventing my PRAGMA directive from being executed? Tim Tim Romano wrote: > I was trying to do > > PRAGMA set case_sensitive_like =1 > > in Adobe Flash Builder Beta 4 and got the following error: > > Error #2044: Unhandled SQLErrorEvent:. errorID=3115, operation=execute , > message=Error #3115: SQL Error. , details=PRAGMA is not allowed in SQL. > > Is this an Adobe error? Or are they passing through a SQLite error? > > Thanks > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ------------------------------------------------------------------------ > > > No virus found in this incoming message. > Checked by AVG - www.avg.com > Version: 8.5.426 / Virus Database: 270.14.91/2541 - Release Date: 12/02/09 > 19:43:00 > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users