[moved] Use of the sqlite table in QML page

[bartek1963]

hi,
how i can use a sqlite table (insert, delete, update) in qml page?

[lemonlinger]

hi, i use it in my app. The functions about sql operations are written in Javascript file, and called in qml page.
Like in JS files:

function loadConf(){
    var db = openDatabaseSync("MatchWordsConf", "1.0", "MatchWords Game Configuration",100);
    var dataStr = "SELECT * FROM Conf"
    db.transaction(
                function(tx){
                    tx.executeSql('CREATE TABLE IF NOT EXISTS Conf(sound NUMBER, music NUMBER, dict TEXT, mode TEXT)');
                    var rs = tx.executeSql(dataStr);
                    console.log("rs.length=" + rs.rows.length);
                    if(rs.rows.length === 0){
                        console.log("noting in conf")
                    }
                }
                );
}

function saveConf(sound, music, mode){
    var db = openDatabaseSync("MatchWordsConf", "1.0", "MatchWords Game Configuration",100);
    var dataStr = "INSERT INTO Conf VALUES(?, ?, ?, ?)";//sound,music,dict,mode
    var data = [sound, music, g_Dict, mode];
    db.transaction(
                function(tx) {
                    tx.executeSql('CREATE TABLE IF NOT EXISTS Conf(sound NUMBER, music NUMBER, dict TEXT, mode TEXT)');
                    tx.executeSql('DELETE FROM Conf');
                    tx.executeSql(dataStr, data);
                    console.log("save OK");
                }
                );
}

[izinin]

You can use QML offline storage api http://doc.qt.nokia.com/4.7-snapshot...ne-storage-api

[bartek1963]

thank so much

[bartek1963]

can i create a in qml a data entry (sql)?

[bartek1963]

Im creating a menu using QML. In the first QML there are some mousearea and each of these sends to another state. Can i create in the next states a data entry or is better use another system ....example form?

[izinin]

Hi

For UI elements (and menu as well) -- it would be better to use QComponents . QComponents ensures your application is in the line with Nokia device application style and user interaction manner. Besides that QComponents saves your time on UI design and implementation. Don't use plain QML

[bartek1963]

thanks i will do

[bartek1963]

have you any example or documentatio?

[izinin]

Hi

QComponents are slightly different for Harmattan and Symbian but as for Menu element -- they are the same . Please check QComponents reference http://harmattan-dev.nokia.com/docs/...onentlist.html and http://doc.qt.nokia.com/qt-component...omponents.html.

Each element description is provided with sample.

Another good resource for QComponents is QComponents application gallery that will give you idea how to use QComponents available elements http://projects.developer.nokia.com/...on/downloads/6

[bartek1963]

Hi,
i have a Symbian (Symbian OS v9.4) device. Can i import QtQuick 1.1 using QtSDK 1.1.2?

[izinin]

Hi

You cannot

Only Qt Quick 1.0 and Qt 4.7.3 is available for S60 5th Edition devices.

However Qt Quick Components is open source so nothing prevents a Qt Quick 1.0 application designed for S60 5th to take QML files for components from Qt Quick Components repository (http://qt.gitorious.org/qt-components) and include it in your project, perhaps with some modification