#cd unixODBC-2.2.14
#./configure --enable-gui=no
#make
#make install

#cd freetds-0.82
#./configure --with-tdsver=8.0 --with-unixodbc=/usr/local
#make
#make install

./configure -I /usr/local/include/ -L /usr/local/lib/ -plugin-sql-odbc
#make
#make install

ALTER procedure [dbo].[fp_test]
(
@Name varchar(50)
)
as
select 777

QCoreApplication a(argc, argv);
QSqlDatabase db = QSqlDatabase::addDatabase("QODBC");
db.setDatabaseName("gambit");
db.setUserName("login");
db.setPassword("password");
if (!db.open()) return 1;

QString strName = "QSql::In string";

QSqlQuery query;
query.prepare("{CALL fp_test(?)}");
query.bindValue("Name",strName);
if (!query.exec()) return 2;

query.bindValue(0, strName);

query.addBindValue (strName);

Цитата(MoPDoBoPoT @ 21.12.2009, 16:18)

ALTER procedure [dbo].[fp_test]
(@Number int out
)
as
select @Number = 777

QSqlQuery query;
query.prepare("{CALL fp_test(?)}");
query.bindValue("Number",n,QSql::Out);
if (!query.exec()) return 2;

n = query.boundValue("Number").toInt();

Цитата(Litkevich Yuriy @ 21.12.2009, 20:14)

QSqlQuery query("SELECT name FROM clients");
query.setForwardOnly(true);
while (query.next())
{  cout << qPrintable(query.value(0).toString()) << endl;
}