I need to get names of columns and save them in strings. SQL statement works correctly (I checked it in SQL manager).
x
//program in QT
QSqlQuery queryTem("tem");
QSqlRecord rec1= queryTem.record();
QString qs={"SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME'"+tableName+"'"};
queryTem.exec(qs);
QString name1= ???
Advertisement
Answer
After exec() use queryTem.next() which retrieves next record in the result until theres any record. And use QVector to store column name. Read more here about QVector.
QVector<QString> columnNames;
while(queryTem.next())
{
columnNames.push_back(queryTem.value(0).toString());
}