Return of the Database

[beowulf]

What is the data format that the database returns to Qt?

For example, I ran a SELECT query in the database, it returns in what format?

You can send this return (format) per socket?

Example, if return an object, that object can send per socket for a client application (socket)?

[costab]

You need to read the documentation for the qtsql module:
http://qt-project.org/doc/qt-4.8/qtsql.html

[Code_ReaQtor]

[quote author="l3e0wulf" date="1352375282"]What is the data format that the database returns to Qt?

For example, I ran a SELECT query in the database, it returns in what format?[/quote]

AFAIK, QVariant.This is what I use after I query from an SQL Database to retrieve the data - "QSqlQuery::value":http://qt-project.org/doc/qt-4.8/qsqlquery.html#value

[quote author="l3e0wulf" date="1352375282"]You can send this return (format) per socket?

Example, if return an object, that object can send per socket for a client application (socket)?[/quote]

Sorry, I can't understand these questions. Can you make it clearer? Provide examples if possible. Thanks

[qxoz]

QSQlQuery returns the QVariant as wrote Code ReaQtor. Maybe you can write your own Class which stores data from table and make it serializable. For example:
@class TableData
{
QString TableName;
QStringList ColumnNames;
QList< QList<QVariant> > TableContent;
}
QDataStream &operator <<(QDataStream &out,const TableData &);
QDataStream &operator >>(QDataStream &in, TableData &);
@

in ***.cpp file
@
QDataStream &operator <<(QDataStream &out,const TableData &tb_data)
{
out << tb_data.TableName << tb_data.ColumnNames << tb_data.TableContent;
return out;
}
QDataStream &operator >>(QDataStream &in, TableData &tb_data)
{
tb_data = TableData();
in >> tb_data.TableName >> tb_data.ColumnNames>> tb_data.TableContent;
return in;
}
@

You can serialize table in QByteArray (up to 2Gb) then transfer via Sockets.

[beowulf]

Thank you.
I'll be trying soon reply to you what happened.