[Qt-interest] Showing a "Please wait" dialog during sql query

[Jason H]

You might want to look into async event notifications, which are supported for PostgreSQL. then port to MySQL if the server supports it. Then it is just signal/slots.





----- Original Message ----
From: Gillen Daniel <gillen.daniel at gmail.com>
To: qt-interest at trolltech.com
Sent: Mon, June 7, 2010 1:31:33 PM
Subject: [Qt-interest] Showing a "Please wait" dialog during sql query

Hi @all

I have a massive problem here and don't seem to find a solution for it.

I'm developping a database application based on a MySQL database and I 
would need to display a "Please wait" dialog while
populating a QSqlQueryModel. The data from QSqlQueryModel gets displayed 
in a widget in my main window, so I have to exec the query in my main 
thread. The problem is that any dialog I open before querying the data 
hangs as my query blocks the main thread.

Does anyone has an idea on how I could solve this? I would need some 
sort of 2nd thread which displays the dialog with his own event loop but 
as far as I understand, Qt does not support GUI interaction in a second 
thread. Or is it perhaps possible to exec the query in a second thread 
and then move the whole QSqlQueryModel and database connection to my 
main thread?

Thx in advance

-- 
Unix _IS_ user friendly - it's just
selective about who its friends are!

_______________________________________________
Qt-interest mailing list
Qt-interest at trolltech.com
http://lists.trolltech.com/mailman/listinfo/qt-interest