Re: [sqlite] QT4 ubuntu sqlite driver problem ? (was Re: [sqlite] Weird error)

2007-08-06 Thread Bill KING
Yeah, there are significant locking issues in sqlite under Qt, in particular if you hold a query open (either via QSqlQuery, or QSqlTableModel et al). clear() is your friend when things start going south. Also, another gotcha to watch out for, if the query fails, check the queries lastError(), not

Re: [sqlite] QT4 ubuntu sqlite driver problem ? (was Re: [sqlite] Weird error)

2007-08-05 Thread Alain Bertrand
John Stanton a écrit : Alain Bertrand wrote: In a Qt4 application, I have the following bit of code : QString s; bool b; QSqlQuery q; QSqlError err; s= "CREATE TABLE ttd_bdata (sheetId integer primary key,"; s+="creation_date date, modif_date date,"; s+="specie

Re: [sqlite] QT4 ubuntu sqlite driver problem ? (was Re: [sqlite] Weird error)

2007-08-05 Thread John Stanton
Alain Bertrand wrote: Joe Wilson a écrit : --- Alain Bertrand <[EMAIL PROTECTED]> wrote: > --- Alain Bertrand <[EMAIL PROTECTED]> wrote: In a Qt4 application, I have the following bit of code : QString s; bool b; QSqlQuery q; QSqlError err; s= "CREATE TABLE ttd_bdat

[sqlite] QT4 ubuntu sqlite driver problem ? (was Re: [sqlite] Weird error)

2007-08-05 Thread Alain Bertrand
Joe Wilson a écrit : --- Alain Bertrand <[EMAIL PROTECTED]> wrote: > --- Alain Bertrand <[EMAIL PROTECTED]> wrote: In a Qt4 application, I have the following bit of code : QString s; bool b; QSqlQuery q; QSqlError err; s= "CREATE TABLE ttd_bdata (sheetId integer primary