Solved do i have to delete query object pointer?

[user4592357]

when i create a QSqlQuery in the heap with database, do i need to delete the object later, or the database takes care of that?
m_pQuery = new QSqlQuery(QSqlDatabase::database());

[SGaist]

Hi,

Yes, you have to.

However, if you re-read the API making use of QSqlQuery, you'll see none of them uses objects allocated in the heap.

[user4592357]

@sgaist
okay, in that case i guess i'll store just a member object.

[SGaist]

Why do you need to store that query as member variable ?

[user4592357]

@sgaist
well i'm creating and executing the query in a data source class (for table view), then each colomn takes the query from the data source and gets appropriate value from it.

[SGaist]

Then you should rather keep the string of the query and build the QSqlQuery object when you actually need it.

[user4592357]

@sgaist
then how will the columns get the results?

[SGaist]

Can you share the code you are using ?
It looks like you could make use of a QSqlQueryModel.

[user4592357]

@sgaist
no i'm on mobile now, and soon to sleep. will take a look at it tomorrow and see if i can use it. thanks

[user4592357]

@SGaist
i took a look at QSqlQueryModel but i guess i can't use it because my table view already has a model.

[SGaist]

What kind ?

[user4592357]

@sgaist
it is QAbstractTableModel

[SGaist]

You can replace your model unless you are doing something special with it ?

[user4592357]

@sgaist
that's the thing. i can't replace it cause it's doing a lot of things (it's part of a library someone has created and I'm using it)

[SGaist]

How are you using it since you need to query a database ?

[user4592357]

@sgaist
it has some long logic built into it, it sets up a lot of connections etc.