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

[Scott Aron Bloom]

I have attached a working solution.  Its not fully vetted, so bugs
probably exist :) but it works in the case shown...


Scott
-----Original Message-----
From: qt-interest-bounces at trolltech.com
[mailto:qt-interest-bounces at trolltech.com] On Behalf Of Jason H
Sent: Monday, June 07, 2010 12:25 PM
To: Gillen Daniel; qt-interest at trolltech.com
Subject: Re: [Qt-interest] Showing a "Please wait" dialog during sql
query

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



      

_______________________________________________
Qt-interest mailing list
Qt-interest at trolltech.com
http://lists.trolltech.com/mailman/listinfo/qt-interest
-------------- next part --------------
A non-text attachment was scrubbed...
Name: sqltest.zip
Type: application/x-zip-compressed
Size: 2808 bytes
Desc: sqltest.zip
Url : http://lists.qt-project.org/pipermail/qt-interest-old/attachments/20100607/125b1079/attachment.bin