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