Re: [sqlite] INSERT questions

2010-05-05 Thread Kees Nuyt
On Tue, 4 May 2010 14:22:25 +0100, "Mark Coles" wrote: >Hi there, > > trying to INSERT a new row into a table and got a few > errors which I think I've sorted, I was getting a > couple of errors that date columns for FirstCreated > and LastModified (datetime Type) may not be NULL, > so I included

[sqlite] INSERT questions

2010-05-04 Thread Mark Coles
Hi there, trying to INSERT a new row into a table and got a few errors which I think I've sorted, I was getting a couple of errors that date columns for FirstCreated and LastModified (datetime Type) may not be NULL, so I included them in my insert line as follows INSERT INTO Aircraft (FirstCr