08-26-2013 12:45 AM
I am tried to get data present in data base as assending orender, But i can't get it. I followed the query shown below, Whats wrong in my code.
Statement statement = database.createStatement("SELECT * FROM Tname ORDER BY Name COLLATE NOCASE ASC");
Any help will be appreciated .
Deepu George Jacob
08-26-2013 04:53 AM
I had a chuckle at your subject:
"assenting" means agreeing. I presume you meant ascending. I recommend you use the spell checker before you post, then other things like this"assending orender" which are confusing won't slip through...
Anyway, thanks for the chuckle, but we had better try to help with your questions.
I don't know SQL very well, but it would surprise me if it did not do exactly what you told it to do.
Can you give us an example of the base data you have (specifically the Name column values), what you expect to get, and what you do actually get. Then people with more knowledge of SQL can look at it and see where the problem is in your SQL statement.
08-27-2013 04:47 AM
Thank you for your response. It is working fine in greater 5.0 OS.
please check the query followed .
08-27-2013 05:01 AM
" It is working fine in greater 5.0 OS."
That would have been useful information to include in your first post.
Can you give us an example of the data that is causing a problem.
I believe there were some issues with non LATIN-1 characters sets in earlier SQLite versions on BB phones. Giving us an example would help confirm if this is the problem.