PDA

View Full Version : QODBC & MSSQL User defined types



giker
17th September 2014, 14:58
Hi. I have MSSQLServer with stored procedures with user-defined types arguments. It allows me to pass array of this type to stored procedure in C#.
I'm writing additional service on Qt for this database.
For regular stored procedures I use code like this:


int param = 1;
QSqlQuery *query = new QSqlQuery(m_sourceDB);
query->setForwardOnly(true);
QString queryStr = QString("{CALL myprocedure(?)} ");
query->prepare(queryStr);
query->bindValue(0, param);
query->exec();


What syntax should I use if stored procedure uses User-defined types?
Thank you.