Goodday fellow QT'ers,
at the moment i am making a program where i use a database.
The database is SQLite and i made several tabels in it and 2 views.
Now here is my problem i got 1 view wich works good with QSQLQuerymodel and the statement is SELECT * FROM view
now there is a 2nd view i made where i need to get data out and wich i inner joined. In this view i need to compare the ID with an int i put it and it needs to give me the value on the same row as that ID.
but here is my problem i cannot seem to get QT work with the view to get the data out. the * works but when i put it SELECT ID, Value FROM view it just won't take it. i am 100% sure the syntax is correct.
when i use the error handling it tells me no such column.... but that is inpossible.
anyone has any ideas how i need to assign the tabels in a SQLite view ?
thanx in advance
Bookmarks