Welcome!

Welcome to the official BlackBerry Support Community Forums.

This is your resource to discuss support topics with your peers, and learn from each other.

inside custom component

Java Development

Reply
Developer
Posts: 235
Registered: ‎12-13-2011
My Device: Curve 9380

Unable to retrieve data in sqlite

Hi,

I am implemented sqlite database in my application. It is working very fine in bb 6 and 7 os. But in 5.0 unable to retrive data . I am manually check database by using sqlitemanager , it contains datas. 

Statement statement = database.createStatement("SELECT FirstName,MobileNumber FROM Contacts");

 The above shown is the query  i am used to retrive data from table

 

Thanks

Deepu George Jacob

Developer
Posts: 19,612
Registered: ‎07-14-2008
My Device: Not Specified

Re: Unable to retrieve data in sqlite

Can you give us an example of the data that this is not retrieving?

Developer
Posts: 235
Registered: ‎12-13-2011
My Device: Curve 9380

Re: Unable to retrieve data in sqlite

Statement  statement = database.createStatement("SELECT FirstName,MobileNumber FROM Contacts");
statement.prepare();
statement.execute();
Cursor cursor = statement.getCursor();
Row r = null;
while(cursor.next())
{
r = cursor.getRow();
System.out.println(" value : "+r.getString(0)+" : "+r.getString(1));
}
statement.close();
database.close();

 This is the code i am used .

Developer
Posts: 19,612
Registered: ‎07-14-2008
My Device: Not Specified

Re: Unable to retrieve data in sqlite

Sorry, I wanted a example of the data that was causing the problem.  Can you show us the the data in the database, and what you actually see in the BlackBerry after it has been extracted.