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"

Qt Code: 
  1. DECLARE @diameterfloat
  2. SET @diameter= 3.0 // just trying to use a variable
  3.  
  4. SELECT [diameter] @diameter
To copy to clipboard, switch view to plain text mode 

How can i make my QSqlQuery do this batch and procedure?