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
