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

Native Development

Reply
Contributor
Posts: 10
Registered: ‎05-20-2013
My Device: Z 10
My Carrier: Blackberry
Accepted Solution

How to view SQLITE database that is being created

In my app Iam using SQLITE database.I found out the code how to create DB and to create record etc.My question is:

Is there any way to view the created DB tables and its fields and the records that is being saved in that tables.I cant find any answer for this I only saw retrieving the data from the table using queries and displaying them in a listView etc.

 

Is it possible to view SQlite DB tables and their fields and the records saved in them.PLz help me out

Developer
Posts: 6,152
Registered: ‎07-05-2012
My Device: Playbook, Dev Alpha C, Z10 LE, Z30
My Carrier: Orange

Re: How to view SQLITE database that is being created

Since this is just a normal SQLite implementation you can use all the normal statements.

 

Take a look here to understand all the queries you wish to do...

 

http://www.sqlite.org/lang.html


If you've been helped click on Like Button, if you've been saved buy the app. Smiley Happy

Developer of stokLocker, Sympatico and Super Sentences.
New Contributor
Posts: 6
Registered: ‎06-02-2013
My Device: Z-10
My Carrier: Verizon

Re: How to view SQLITE database that is being created

[ Edited ]

Mshihas wrote:

In my app Iam using SQLITE database.I found out the code how to create DB and to create record etc.My question is:

Is there any way to view the created DB tables and its fields and the records that is being saved in that tables.I cant find any answer for this I only saw retrieving the data from the table using queries and displaying them in a listView etc.

 

Is it possible to view SQlite DB tables and their fields and the records saved in them.PLz help me out


Also you can view your tables using sqliteman.

Developer
Posts: 6,152
Registered: ‎07-05-2012
My Device: Playbook, Dev Alpha C, Z10 LE, Z30
My Carrier: Orange

Re: How to view SQLITE database that is being created

If you are asking to view the database outside of BlackBerry coding, say on the desktop, then I can recommend sqlitestudio.


If you've been helped click on Like Button, if you've been saved buy the app. Smiley Happy

Developer of stokLocker, Sympatico and Super Sentences.
Developer
Posts: 148
Registered: ‎04-08-2013
My Device: Blackberry 10
My Carrier: Blackberry

Re: How to view SQLITE database that is being created

[ Edited ]

Is there any built in support for cascades SDK for viewing the DB.
Is it possible to use sqliteman in cascades.Plz prove some links to use sqliteman

Highlighted
Developer
Posts: 16,986
Registered: ‎07-29-2008
My Device: Z10 LE, Z30, Passport
My Carrier: O2 Germany

Re: How to view SQLITE database that is being created

In Momentics choose the Target File System Navigator view. You can use "copy to file system" to copy the database to your PC.
On the PC i use the Firefox plugin "SQLite Manager" to view and manipulate the database. You can find it using the plugin manager.
----------------------------------------------------------
feel free to press the like button on the right side to thank the user that helped you.
please mark posts as solved if you found a solution.
@SimonHain on twitter
Contributor
Posts: 10
Registered: ‎05-20-2013
My Device: Z 10
My Carrier: Blackberry

Re: How to view SQLITE database that is being created

Thanks simon.I have a problem while implementing your solution.
In momentics ->Window ->showView ->target file system navigator
when I do this a view appears which contains textField for path.
Then on one side it shows the IP of my simulator and nothing more how to procced from here.Plz help me
Developer
Posts: 16,986
Registered: ‎07-29-2008
My Device: Z10 LE, Z30, Passport
My Carrier: O2 Germany

Re: How to view SQLITE database that is being created

you should be able to expand that and see the different folders.
have not tried it with the simulator though, only a real device.
----------------------------------------------------------
feel free to press the like button on the right side to thank the user that helped you.
please mark posts as solved if you found a solution.
@SimonHain on twitter
Developer
Posts: 148
Registered: ‎04-08-2013
My Device: Blackberry 10
My Carrier: Blackberry

Re: How to view SQLITE database that is being created

That works fine for me Smiley Happy