Re: [sqlite] Sqlite3_step problem

[Stephan Beal]

On Tue, Aug 2, 2011 at 12:49 PM, Prasanth R Kosigi Shroff <
prasanth@globaledgesoft.com> wrote:

> 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.
> ...what could be the reason
>

Can you show us the C code? Without that we can only guess.

-- 
- stephan beal
http://wanderinghorse.net/home/stephan/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Sqlite3_step problem

[Prasanth R Kosigi Shroff]

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