Re: [sqlite] SQLite version 3.6.18 scheduled for Monday

Thanks D Hipp Your software is marvelous, as is the help on this list. I had to rework one delete statement, for reasons I still don't get, but otherwise awfully good stuff. I made it work another way. I worked with some of the people who invented DB2. Was a hell of a lot of fun. I

[sqlite] Is rowid sequential?

Hi All I have an extremely simple little database with one table. I have an embedded app that keeps the database open forever and this table is manipulated by a single thread. I need to make sure this table doesn't get too big - no more than N rows. There is a Start_Time column which holds

Re: [sqlite] DELETE ststement not working as expected

Thanks Shane, but I do not believe that is the issue. I bind these values in my INSERT statements and it works fine. Otherwise I wouldn't have a DELETE problem, would I? ;) Also, the values are acceptable if I try my DELETE at the SQLite command prompt. -Original Message- From:

[sqlite] DELETE ststement not working as expected

Hi All I have the following simple table: CREATE TABLE log ( Channel INT, Start_Time INT, End_Time INT, Data_Value BLOB); And I have this delete statement: DELETE FROM log WHERE Start_Time <= ?; I prepare this statement when I open the database, along with a bunch of others. I keep