Baasie
2nd September 2009, 15:21
Good day fellow QT'ers.
i am not sure if this is a newbie question or not so i just posted here.
I made several databases with in an SQLite db and made a view to combine 3 of em to 1 view.
Now is my question i can get all these seperated database into a QSqlTableModel and it shows on my QTableView. But the moment i try to do this with the view of the db file it does not show. It will show the names of the colums like: Main.id where main is the table and id the colum....
so in the end it does not show does anyone know why (because i want to use this to let the user edit the tables in real time.. and yes i am aware that SQLite does not use update on his views but with triggers this might be doable that is why i want to do this :).
many thanx in advance for your help :)
regards Kenny Baas
i am not sure if this is a newbie question or not so i just posted here.
I made several databases with in an SQLite db and made a view to combine 3 of em to 1 view.
Now is my question i can get all these seperated database into a QSqlTableModel and it shows on my QTableView. But the moment i try to do this with the view of the db file it does not show. It will show the names of the colums like: Main.id where main is the table and id the colum....
so in the end it does not show does anyone know why (because i want to use this to let the user edit the tables in real time.. and yes i am aware that SQLite does not use update on his views but with triggers this might be doable that is why i want to do this :).
many thanx in advance for your help :)
regards Kenny Baas