07-25-2012 10:53 AM
looking to setup my first sql database for an app and was wondering a couple things. I know many of the sample apps show this process in detail and I will use them but I was additionally wondering how to create the database? The sample apps contain a .db file, which I know is for the database but is it created within the app? Or separately and can I just name it .db like with qml's or is there a more advanced creation process? Any documentation or personal experience with this would be welcome and appreciated.
Solved! Go to Solution.
07-25-2012 11:23 AM
View qt documentation :
I worked in qt project to access and create SqlLite db, and yes, you can create db on the fly.
Hope this help you.
07-25-2012 11:35 AM
More especific link :
Click on "More" link
07-25-2012 12:29 PM
I keep getting errors with any of the SQL api, such as:
undefined reference to `bb::data:qlConnection:qlConnection(QString const&, QString const&, QObject*)'
undefined reference to `bb::data::AsyncDataAccess::isRunning()'
I am not sure what I am missing, I have included this to begin:
using namespace bb::cascades;
as well as my header file, is there something else necessary? Even the sample apps for sql are not working, though I just copied their assets and source folders instead of importing them fully, could I have missed something outside of these files?
07-25-2012 12:50 PM
I seriously recommend you Qt classes for Sql management. It works.
07-25-2012 01:08 PM
oh I was just basing it off of the samples, if the qt is more efficient I will read further. I just appreciated having a template like in provided samples. The emoticons were based off of for the :ql, an odd accident. So I'll really read up on using the Qt classes, I assume many of the principles would be the same as I have already seen. Have you worked with the new sql management at all? Or do you just find it not as useful as Qt?
07-25-2012 02:42 PM
Qt works very very very well. Don't know the "blackberry method"