You are not logged in.

Dear visitor, welcome to QtForum.org. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

1

Thursday, June 26th 2014, 2:58pm

Qt postgres stored procedures

Hello, i have a trouble, i have a postgres stored function that should retrieve a ref cursor, when i call it with this instructions:


qdb.prepare("SELECT * from myfunction('cursor'); fetch all in cursor" );
qdb.exec();


and i try to show it in a tableview:


QSqlQueryModel *model = new QSqlQueryModel;

model->setQuery(qdb1);

ui->tableView->setModel(model);


In the tableview i only see the name of the cursor instead of the table.


So where's the problem? ?(
when i use the same SQL query in pgadmin it returns me the table, so it goes good, but does it go wrong in Qt? Where am i wrong? ?(
Thenks for the help!! :)

Similar threads