Thank you for visiting the BlackBerry Support Community Forums.
BlackBerry will be closing the BlackBerry Support Community Forums Device Forums on April 1st (Developers, see below)
BlackBerry remains committed to providing excellent customer support to our customers. We are delighted to direct you to the CrackBerry Forums, a well-established and thorough support channel, for continued BlackBerry support. Please visit http://forums.crackberry.com or http://crackberry.com/ask. You can also continue to visit BlackBerry Support or the BlackBerry Knowledge Base for official support options available for your BlackBerry Smartphone.
"When we launched CrackBerry.com 10 years ago, we set out to make it a fun and useful destination where BlackBerry Smartphone owners could share their excitement and learn to unleash the full potential of their BlackBerry. A decade later, the CrackBerry community is as active and passionate as ever and I know our knowledgeable members and volunteers will be excited to welcome and assist more BlackBerry owners with their questions."
- Kevin Michaluk, Founder, CrackBerry.com
Developers, for more information about the BlackBerry Developer Community please review Join the Conversation on the BlackBerry Developer Community Forums found on Inside BlackBerry.
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.