#include <QtGui>
#include <QSqlDatabase>
#include <QSqlError>
#include <QSqlQuery>


int main(int argc, char *argv[])
{
    QApplication a(argc, argv);

    QSqlDatabase db= QSqlDatabase::addDatabase("QODBC");
    QString connectionString = "DRIVER={SQL Anywhere 11};SERVER=MyDatabase;UID=XXXX;PWD=XXXX;DATABASE=C:/DemoDbAnywhere/MyDatabase.db;";
    db.setDatabaseName(connectionString);


    if(!db.open())
    {
        QMessageBox::warning(0, "Open database failed", db.lastError().text(), QMessageBox::Ok);
        return 1;
    }


       // ESSAI BIND BOUND WITH PRCEDURE
       QSqlQuery q2(db);
       q2.setForwardOnly(true);

       q2.prepare("call essai1(:param1, :param2)");

       q2.bindValue(":param1", "bernard");
       QString myString = "paris";
       q2.bindValue(":param2", myString, QSql::Out);

       if (!q2.exec())
       {
           QMessageBox::warning(0, "query failed", q2.lastError().text(), QMessageBox::Ok);
           return 2;
       }
       else
       {
           qDebug() << "executed query: " << q2.executedQuery();
           qDebug() << ":param1: " <<q2.boundValue(":param1").toString(); // expected bernard => ok
           qDebug() << ":param1: " << q2.boundValue(":param2").toString(); // expected paris => failed return "ber"

       }


    return 0;
}