Cascades Development

[vingilot]

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.

[blackqtcoder]

View qt documentation :

Http://qt-project.org/doc/qt-4.8/qtsql.html

I worked in qt project to access and create SqlLite db, and yes, you can create db on the fly.

Hope this help you.

[blackqtcoder]

More especific link :

Http://qt-project.org/doc/qt-4.8/qsqldatabase.html

Click on "More" link

[vingilot]

I keep getting errors with any of the SQL api, such as: 

undefined reference to `bb::data:qlConnection:qlConnection(QString const&, QString const&, QObject*)'

and 

undefined reference to `bb::data::AsyncDataAccess::isRunning()'

I am not sure what I am missing, I have included this to begin:

#include <bb/data/DataAccessReply>
#include <bb/data/SqlConnection>
#include <bb/data/SqlDataAccess>

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?

[blackqtcoder · Accepted solution]

I seriously recommend you Qt classes for Sql management.  It works. 

[vingilot]

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?

[vingilot]

While I will continue investigating your method, the original problem has been rectified, my .pro file was missing the correct library.

[blackqtcoder]

Qt works very very very well. Don't know the "blackberry method"