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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
