Russian Qt Forum

#include <QtSql>
#include <QTextStream>
#include <QTextCodec>
static bool createConnection()
{
    QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
   	db.setDatabaseName("base.db3");
	if (!db.open()) {
        qDebug() << "Cannot open database:" << db.lastError();
        return false;
    }
    return true;
}

int main(int argc, char** argv)
{
    QTextCodec* winCodec = QTextCodec::codecForName("Windows-1251");
	QTextCodec::setCodecForTr(winCodec);
	QTextCodec::setCodecForCStrings(winCodec);
	QTextCodec::setCodecForLocale(winCodec);

	QCoreApplication app(argc, argv);
	QFile file("text.txt");
	QTextStream stream(&file); 
    if (!createConnection()) {
        return -1;
    }
    QSqlQuery query;
    QString   str  = "select * from main order by adigabza";

    if (!query.exec(str)) {
        qDebug() << "Unable to select a table";
    }
    QSqlRecord rec     = query.record();
    QString    strAdigabza;
    QString    strRussian;
    int    intLength;
	file.open(QFile::WriteOnly);
	while (query.next()) {
  strAdigabza = query.value(rec.indexOf("adigabza")).toString();
	 strRussian = query.value(rec.indexOf("russian")).toString();
     intLength  = query.value(rec.indexOf("length")).toInt();
	 stream << strAdigabza<<" "<<strRussian<<" "<<intLength<<";";
    }

    return 0;
}