2008/4/25 lrjanzen <[EMAIL PROTECTED]>: > > I have the following table ... > and the following insert > INSERT INTO Sighting (SpeciesID,LocationID,SightingDate,Note) > VALUES (3005,22,'2/26/2008','New Note') > > the insert works EXCEPT the date keeps coming in as NULL! What am I doing > wrong? > > Thanks > Lonnie >
On XP I get SQLite version 3.4.2 Enter ".help" for instructions sqlite> sqlite> CREATE TABLE Sighting ( ...> SightingId integer PRIMARY KEY AUTOINCREMENT NOT NULL, ...> SpeciesId integer, ...> LocationId integer, ...> SightingDate date, ...> Note nvarchar(100) ...> ); sqlite> sqlite> INSERT INTO Sighting (SpeciesID,LocationID,SightingDate,Note) ...> VALUES (3005,22,'2/26/2008','New Note'); sqlite> select * from sighting; 1|3005|22|2/26/2008|New Note sqlite> What operating system, version, wrapper? Rgds, Simon _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users