>Newbie here. i'm trying to insert multiple values into a table by a
>certain
>date and when I use where clause it fails. This is my code "insert
>into db
>(table) values ('value') where date = 'date range'". Thanks for any help.
There is no where clause in insert statements, it wouldn't make sense.
Your insert should look like:
insert into mytable (datecolumn) values
(litteral_date_in_the_format_you_choose);
See http://www.sqlite.org/lang_insert.html
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
