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

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)

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,";

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

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

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

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

Re: [sqlite] Weird error

--- 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 key,"; > s+="creation_date date, modif_date date,"; >

[sqlite] Weird error

Hi all 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+="speciesId integer,USDA_zone integer,";