On 6/29/07, Dennis Birch <dennisbirch at gmail dot com> wrote:
> The database could have been created with RB 2007R2, but that is as
> far back as it possibly could have gone.
Mystery solved! My application lets users set a boolean value for all
the records that match a "job ID" to true or false. In that one
particular case I use a raw SQL statement to handle it without looping
through records. The method that performs that update was getting its
boolean value for the SQL statement from a function that returns
"true" or "false" instead of 1 or 0. I apparently tested that feature
and populated my database with useless values for several records.
It's too bad that SQLite lets you do that, and doesn't raise an error
when you try to enter the wrong type of data for a column.
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives:
<http://support.realsoftware.com/listarchives/lists.html>
|