Currently I'm getting an error:
SQLError: 'Error #3115: SQL Error.', details:'no such function: 'Len'', operation:'execute', detailID:'2094'
Query (pretty simple):
SELECT id, term FROM terms_table WHERE term LIKE :tmpTerm ORDER BY LEN(term);
Query works fine on SQLite admin interface - QA.
Any idea why I get an error msg?
Can someone confirm that "NO" is the answer?
OK, go it!
Guess SQLite2009 Pro convert what seems to be legit SQL function (works on MS SQL) to the equivalent in SQLite. Therefor, len() in SQLite should be written as length(). Yes, it's that simple but still cost me couple of days .