hi i am trying to run a compiled query and i am passing it through sqlite3_step API the return value is SQLITE_DONE. But the same query works fine when i execute the same query using command line tool.
#sqlite3 tmp.db SQLite version 3.4.2 Enter ".help" for instructions sqlite>select name from (select * from some_tbl order by length(name), name) where ((length(name) > length('MANGO')) or (length(name) == length('MANGO') and (name > 'MANGO'))) limit 1; name = TANGO what could be the reason Regards, Prasanth K S R _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users