Re: [sqlite] insert help

2011-04-20 Thread Petite Abeille
On Apr 20, 2011, at 10:25 PM, ArbolOne wrote: > Hell! any body? http://tinyurl.com/4yxf2gc ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] insert help

2011-04-20 Thread ArbolOne
Hell! any body? - Hey folks. I would like to use sqlite in a C++ program. Is there a place in the internet where I can see C/C++ examples of sqlite? TIA -- All things in life are temporary. If going well enjoy it, they will not last forever. If going wrong don't worry, they can't

Re: [sqlite] insert help

2011-04-19 Thread Igor Tandetnik
On 4/19/2011 1:59 PM, vquickl27 wrote: > Jean-Christophe Deschamps-3 wrote: >> So you need to perform as many inserts as values you have to insert: >> insert into mytable (date, value) values ('2011/04/18 21:35:33', 1); >> insert into mytable (date, value) values ('2011/04/18 21:35:33', 2); >>

Re: [sqlite] insert help

2011-04-19 Thread vquickl27
Jean-Christophe Deschamps-3 wrote: > > >>My date column is set when the program starts and i do not want it to >>change. > > How is this date column set in the database without inserting anything? > >> So I have my with and two columns and >>. I have say 5 values (1 2 3 4 5) that I

Re: [sqlite] insert help

2011-04-19 Thread Jean-Christophe Deschamps
>My date column is set when the program starts and i do not want it to >change. How is this date column set in the database without inserting anything? > So I have my with and two columns and >. I have say 5 values (1 2 3 4 5) that I wanted inserted >into mytable where the date is equal

Re: [sqlite] insert help

2011-04-19 Thread vquickl27
Jean-Christophe Deschamps-3 wrote: > > >>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

Re: [sqlite] insert help

2011-04-19 Thread Jean-Christophe Deschamps
>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

[sqlite] insert help

2011-04-18 Thread vquickl27
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. -- View this message in context: