XChinux
20th June 2008, 07:11
Does Qt 4.4.0's TDS Engine support transaction and storage procedure's
call. There is output parameter and returned recordset in the storage
procedure.
for examples:
SQL Script:
----------------------
declare @aaa float
set @aaa = 10.0
exec proc1 @aaa output
-----------------------
Qt Code:
-----------------------
QSqlQuery q;
q.prepare("exec proc1 ?");
q.bindValue(0, 0, QSql::Out);
q.exec();
double f = q.boundValue(0).toDouble(); // fetch the output parameter
------------------------
Thanks.
call. There is output parameter and returned recordset in the storage
procedure.
for examples:
SQL Script:
----------------------
declare @aaa float
set @aaa = 10.0
exec proc1 @aaa output
-----------------------
Qt Code:
-----------------------
QSqlQuery q;
q.prepare("exec proc1 ?");
q.bindValue(0, 0, QSql::Out);
q.exec();
double f = q.boundValue(0).toDouble(); // fetch the output parameter
------------------------
Thanks.