using an isntance of QSqlDatabase for connection defiinition

[jfinn88]

conn1 is the name of db connection not C++ variable. Variable name is m_insertDataBase - C++ ABC.
And line 4

m_insertDataBase = QSqlDatabase::database("conn1");

m_insertDataBase = QSqlDatabase::database("conn1");

To copy to clipboard, switch view to plain text mode 

is unnecessary.

It didn't seem to work when passing the driver and the connection name with the line of code above this one. So I tried setting the connection name again but kept getting "conn1 was not declared in this scope". I know conn1 is the db connection name I declare it in the code above and in this line and I declare the instance variable in my header file. I only used the above code seeing if setting the db connection name would work like this I realize its unnecessary, I was just trying something to get it to work. I'm not sure if I need to declare the instance variable under public or not in the header file?

---

Added after 4 minutes:

You also don't want to do the addDatabase() and setDatabaseName() calls every time, just once, when "m_insertDataBase" is not valid yet.
See QSqlDatabase:::isValid().

Also, as someone had already pointed out in another thread, don't concatenated an input string into a SQL Query, always use prepare() and bound values for proper escaping.

Cheers,
_

You are talking about binding my Msg variable correct? the parameter I'm using in my sql statement?

I was using a prepare statement before but took it out to try to short my code and it only takes one parameter wasn’t sure how to tell if its using the right connection. I will go back to using the prepare statement as suggested to allow proper escaping. How do I set the conn1 connection since The prepare() fcn only takes one argument can't pass it the connection name with sql statement do I just set the connection by

m_selectDataBase = QSqlDatabase::database("conn2");

m_selectDataBase = QSqlDatabase::database("conn2");

To copy to clipboard, switch view to plain text mode 

I will look at documentation on isValid(). How do I only call those methods once when the instance is not valid? little explanation on how this works be great, you got a example?