How to store a array with QML in database
-
Hello All,
I want to store some informtaion persistently, for that i am using the QML openDataBaseSync method, but i am not getting how i can store list of values associated with a key in my database.
I can store a single value with key and populate it one my ui, but suppose i have a Food Item as my key like burger and i want to store two values like rating and comments associated with burger how can i do that.
Any information will be appreciated. :-)
Thanks
-
Just create a new table in the SQL database that will be called Food and will have all the appropriate fields.
Also create
@
'Food(name TEXT, rating TEXT, comment TEXT)'
@Then it is all up to SQL usage to use the SET and UPDATE to retrieve the info that you want.