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 (FirstCreated,LastModified,ModeS) values ('2010-05-04 09:21:31','2010-05-04 09:21:31','C40000'); and it seems to have worked as that row is now in my (test)database, what I was wondering about were the boolean fields, they are all filled in with zeroes, so this is a good sign, yes? Also, what about the relationships between this table and others in the database, should everything be OK as I want to share this but not screw up other peoples databases mtia Mark _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users