Hi All,
I am using existing database (.sqlite) file in meego netbook application but sql query does not gives any output however database open condition is always true. I have put .sqlite file in project folder and install it in /var/opt/ folder.
please clarify how can i able to acheive this purpose. Is there any installation path mistake?

Regards,
aayushi

aayushi,

1.) Are there any records in the table you are querying?
2.) Have you stepped through your code at runtime to see what is returned?

Hi BrianDevArch,
Thanks for the reply
Yes database containg many table ,but it does not give output. I have put (mydemo.sqlite) database in project folder.

project file contains:

OTHER_FILES += \
mydemo.spec \
mydemo.sqlite\
mydemo.desktop

target.path =/opt/com.companyname.mydemo/
icon.files =Icon/16/mydemo.png
icon.path =/usr/share/icons/
icon16.files =Icon/16/mydemo.png
icon16.path =/usr/share/icons/16x16/
icon32.files = Icon/32/mydemo.png
icon32.path = /usr/share/icons/32x32/
icon64.files = Icon/64/mydemo.png
icon64.path = /usr/share/icons/64x64/
icon128.files =Icon/128/mydemo.png
icon128.path =/usr/share/icons/128x128/
desktop.files =mydemo.desktop
desktop.path =/usr/share/applications/
icons.files =Icon/mydemo.png
icons.path =/usr/
database.files=/mydemo.sqlite
database.path=/var/opt/com.companyname.mydemo/

INSTALLS += target icon icon16 icon32 icon64 icon128 desktop icons database

*******************************************************************************
dabaseconnection.cpp contains:

QSqlDatabase DB;
DB = QSqlDatabase::addDatabase("QSQLITE");
#ifdef Q_OS_LINUX
// NOTE: We have to store database file into user home folder in Linux
QString path(QDir::home().path());
path.append(QDir::separator()).append("mydemo.sqlite");
path = QDir::toNativeSeparators(path);
DB.setDatabaseName(path);
#else
// NOTE: File exists in the application private folder, in Symbian Qt implementation
DB.setDatabaseName("mydemo.sqlite");
#endif
// Open database
DB.open();
if( DB.open())
{
qDebug()<<"open";
}
else
{
qDebug()<<"close";
}

please clarify me how can i use existing database in my application.

Hello,

Thank you for you interest in the Intel AppUp(SM) Developer Program.

Yes, you got it right for your first 3 statements.

Regarding the GUID, in order for you to submit your applications to Intel for validation, you need to go through the submission process. The process is simple. You can get there by clicking on 'My Dashboard'. When you 'start an application', it automatically generates a unique GUID for the particular app. This is the GUID you need to put in your codes.

You will find more information on developing apps for Meego for Intel AppUp(SM) Center on the following links:
http://appdeveloper.intel.com/en-us/meego-develop
http://appdeveloper.intel.com/en-us/sdk (please refer to the API release notes on the left hand side of the page)

I hope this helps.

Please do not hesitate to contact us if you have any other queries.

Regards
Rooven

Intel AppUp(SM) Center
Intel AppUp(SM) Developer Program

@Vsh.Vshnu Yes you can. My apps uses Qt APIs and works just fine on MeeGo. Qt is available on MeeGo from the box.

Hi Vsh.Vshnu!

Due to these recommendations you should use "/var/opt/com.yourcompanyname.appname/" directory to place your database file.

http://appdeveloper.intel.com/en-us/article/meego-packaging-and-compliance-guidelines

Regards,
Dmitry