baray98
17th July 2009, 17:44
I am trying to build an app like a query analyzer interface, which the user can type thier SQL statement and hit run then the result will be displayed on a tableview which is connected to a SQLmodel.
My driver is QOBDC and my database is MS SQL
Simple statements are ok QSql but i want to support BATCH execution and PROCEDURE calling I tried to feed statement like this and its just hang (or after one execution it will come back with "busy with the result from another hstmt"
DECLARE @diameterfloat
SET @diameter= 3.0 // just trying to use a variable
SELECT [diameter] @diameter
How can i make my QSqlQuery do this batch and procedure?
My driver is QOBDC and my database is MS SQL
Simple statements are ok QSql but i want to support BATCH execution and PROCEDURE calling I tried to feed statement like this and its just hang (or after one execution it will come back with "busy with the result from another hstmt"
DECLARE @diameterfloat
SET @diameter= 3.0 // just trying to use a variable
SELECT [diameter] @diameter
How can i make my QSqlQuery do this batch and procedure?