On Sep 28, 2006, at 11:30 AM, Phil M wrote:
On 28.09.2006, at 10:18, Norman Palardy wrote:
I have to look into this further, but the result of this bug is
even worse. It appears that the SQL is not written to the
REALSQLdatabase *and* no DB.Error occurs (a silent death).
The second portion of your double is probably in the wrong column
since SQLite will let you do that. Or do you not get the row at
all ?
In this particular case, the data was in the very last column -- so
the SQL statement appears like there is one additional value with
no column to link it to. There *should* be an SQL error that the
statement is invalid; but instead (at least in my app) the INSERT
statement is not being processed and no Error is reported.
Hard to know if it SQLite forgiving things that it should not or just
the error not being reported
A quick test here suggest SQLIte does give you an error when there
are more values than columns in something like
create table test ( a integer , b varchar(100) )
insert into test ( a , b ) values ( 1,1,1,1 )
In my test app using the older SQLIte plugin I do get an error saying
"4 values for 2 columns"
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
|