Qt/SQL - Get column type and name from QSqlQuery exec Stored Procedure?

user_5346335 0
Viewed 2397

I've connected to MSSQL server using QSqlDatabase class. Then I can get stored procedures' results with QSQLQuery like:

QSqlQuery q;
q.prepare ("EXEC TestStoredProcedure");
if (q.exec ()) { 
    while (q.next ()) {
        qDebug() << q.value (0).toString ();
        ...
    }
}

So, I have values of the returned fields, but how I can get fields' names and types? Stored procedure can form the list of returned fields dynamically.

Thanks for any help and answers!

qsqlquery qt5 qt sql c++
1 Answers

You can use QSqlRecord. For example:

QSqlRecord localRecord = q.record();
for (int var = 0; var < localRecord.count(); ++var) {
    QString fieldName = localRecord.fieldName(var);
    qDebug() << fieldName;
}

or

QSqlRecord localRecord = q.driver()->record("table");
for (int var = 0; var < localRecord.count(); ++var) {
    QString fieldName = localRecord.fieldName(var);
    qDebug() << fieldName;
}

I think you can work without column type.

user_103545610
Related