Return of the Database

? Offline

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)?

? Offline

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.

? Offline

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