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.
01-21-2013 12:22 PM - edited 01-21-2013 12:27 PM
Once I have created a connection to my local DB Table, I can INSERT as many times as I want. Using that same DB Table, I cannot UPDATE/DELETE that same row (the one I just inserted). SELECT works just fine and I haven't received any SQL errors.
I am positive all of my SQL commands are typed properly and function as I have tested them on other data in the same DB table that was created outside of my application. It seems that once my application has altered any of the information in that row, the row becomes locked
Any ideas? Thanks
Solved! Go to Solution.
01-21-2013 12:42 PM
#include <bb/data/DataSource> #include <bb/data/SqlConnection
I am having the same issue using the customsqldatasource from quotes sample app (issue is in my app not the sample app)
I use the same execute function for all my queries, I only have an issue after I have done an INSERT/UPDATE to any given row. If I run those queries on data already in the db (I created my assets/xxx.db with data included) they work fine...the first time, if I run the same queries on the now altered row, the queries do nothing
01-22-2013 07:31 AM - edited 01-22-2013 07:40 AM
I'm not sure if this could be the reason, but assets folder is readonly (at least in signed builds). In order to be modified, the database should be copied to data folder and opened from there. This can be done on the first run of the application.
Example of accessing the data folder:
01-23-2013 09:45 AM - edited 01-23-2013 09:45 AM
I was able to solve the issue, guess I wasn't paying enough attention when I was rereading my INSERT queries, I had put single quotes around the int index, so I needed those quotes on the other queries