[Qt-interest] QSqlQuery caching INSERT data?

Israel Brewster israel at frontierflying.com
Thu Nov 19 22:04:48 CET 2009


Does QSqlQuery do any caching of INSERT statements? If so, is there a  
way to force the cache to be flushed to the database? I have a program  
that executes a number of INSERT statements using QSqlQuery, but they  
don't seem to be written to disk until the app quits. Usually this  
isn't a problem, and is probably a good thing, but there are a couple  
of places where this doesn't work for me. I tried using a  
QSqlDatbase::close() command, but this doesn't seem to produce the  
desired result. I didn't think QSqlQuery did any caching aside from  
results, which makes me think this is a SQLite process that doing the  
caching, but I wanted to ask here anyway. Even if it is SQLite, is  
there some Qt command I could run to make SQLite think I am done and  
write the data out? Thanks for any advice!

-----------------------------------------------
Israel Brewster
Computer Support Technician II
Frontier Flying Service Inc.
5245 Airport Industrial Rd
Fairbanks, AK 99709
(907) 450-7250 x293
-----------------------------------------------



-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.qt-project.org/pipermail/qt-interest-old/attachments/20091119/6b74c256/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Israel Brewster.vcf
Type: text/directory
Size: 417 bytes
Desc: not available
Url : http://lists.qt-project.org/pipermail/qt-interest-old/attachments/20091119/6b74c256/attachment.bin 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.qt-project.org/pipermail/qt-interest-old/attachments/20091119/6b74c256/attachment-0001.html 


More information about the Qt-interest-old mailing list