Using qml sql to pull data but how can I use it to be displayed.
-
I'm using this .js
@
var index_count = 0
var up_check = 0
function get_db(a, up_check) {var db = LocalStorage.openDatabaseSync("DB5", "1.0", "The Example QML SQL!", 10000); db.transaction( function(tx) { /* tx.executeSql('CREATE TABLE IF NOT EXISTS Greeting(salutation TEXT, salutee TEXT)'); for ( var z=0; z<1000; z++){ tx.executeSql('INSERT INTO Greeting VALUES(?, ?)', [ 'Movie', z ]); } */ var rs = tx.executeSql('SELECT * FROM Greeting'); var r = "" for(var i = 0; i < a; i++) { if (i>index_count-1 && up_check ===0) r += rs.rows.item(i).salutation + ": " + rs.rows.item(i).salutee + "\t\t" if (up_check === 1){ var size_check =0 if (i >index_count-11 && size_check !==9) { r += rs.rows.item(i).salutation + ": " + rs.rows.item(i).salutee + "\t\t" size_check++ } } } console.log(r); index_count=a; return r; })}
@
for pulling data from a database and this is how I'm calling the function from the qml
@ Logic.get_db(5,0)@How can I use the data pulled from the function to use like an imge or txt in qtquick
I'd love to be able to place the data in specific spots. -
I think that you can find in this "learning guide":http://releases.qt-project.org/learning/developerguides/qtquickdesktop/QtQuickApplicationGuide4Desktop.pdf how to read from the database.