Discussion Board

Results 1 to 4 of 4
  1. #1
    Registered User
    Join Date
    Sep 2012

    Unhappy How to use local database in N9 application

    First,please forgive my little english.
    I 've met with this problem for a long time.
    I am going to develop an application that can search some infomation in my local database.
    In my qml file ,i use the following codes to link database. (I mean that my databse is not empty at first,I 've put some data in it ,and i just want to use its data in this application.)

    function getDatabase() {
    return openDatabaseSync("MyDB", "1.0", "Mine", 5244928);
    } //open sqlite databse
    function appendListModelData(busNumInput)
    var db = getDatabase();
    menuData.clear(); //clear all the listView element at first
    db.transaction(function(tx) {
    var rs = tx.executeSql('SELECT * FROM train');
    //* This is part of my codes

    In my Qt Simulator,it is ok to lunch the local database
    in this directory:"C:\Users\Administrator\AppData\Local\Nokia\QtSimulator\data\QML\OfflineStorage\Databases\"

    So i save my databse in here.And i can visit the data in this file easily in my Simulator QT for Visual 2008.

    However,when i pack my app to deb package and deploy it to my N9 ,it cant visit the database's data.
    So,i want to know ,how should i visit my database in my N9,where it would be in my N9?
    And if i want to visit it in my phone,how should i deploy my databse, and in which directory it should be?

  2. #2
    Registered User
    Join Date
    Mar 2009

    Re: How to use local database in N9 application

    I have never used sqlite thru qml...I suggest to use backend c++ instead and pack all thru DEPLOYMENTFOLDER.
    Merry Christmas Tombola! available on OVI Store!
    SuperDaddy available on OVI Store!

    QT VirtualKeyboard: http://qt-apps.org/content/show.php/VirtualKeyboard?content=107388
    Crack Generator: http://qt-apps.org/content/show.php/MosaicCrack?content=121832

  3. #3
    Registered User
    Join Date
    Sep 2011

    Re: How to use local database in N9 application


    Please refer to DataStorage Location in this page.

    - Kusuma

  4. #4
    Registered User
    Join Date
    Sep 2012

    Re: How to use local database in N9 application

    thank you ,i 've know some better method now ...

Similar Threads

  1. how to access correctly to a local dataBase (SQLite3)
    By sami.mahjoub in forum Nokia N9
    Replies: 1
    Last Post: 2011-02-12, 09:44
  2. few mixed queries on local sms and database
    By yahoo2010 in forum Symbian
    Replies: 9
    Last Post: 2010-08-22, 16:49
  3. Custom Local Database on 5th Edition
    By b.tiru.naidu in forum OMA DM/DS/CP
    Replies: 0
    Last Post: 2010-06-09, 15:24
  4. local database for application on N95 mobile
    By burinutit in forum Mobile Java General
    Replies: 7
    Last Post: 2010-06-05, 07:52
  5. Opening a local database file
    By ppezziardi in forum Mobile Java General
    Replies: 4
    Last Post: 2003-05-08, 14:02

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts