What does the built StrQuery actually look like? That should 'splain things. I imagine the 16 is in your dataGridView values. And are those values numbers or strings?
-----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of mikkelzuuu Sent: Tuesday, February 19, 2013 3:40 AM To: sqlite-users@sqlite.org Subject: [sqlite] SQLite error near "16": syntax error Hey guys, I'm getting this error (see title) I'm using C# by the way. string StrQuery = @"INSERT INTO Test VALUES (" + dataGridView1.Rows[i].Cells["Column1"].Value + ", " + dataGridView1.Rows[i].Cells["Column2"].Value + ", " + dataGridView1.Rows[i].Cells["Column3"].Value + ", " + dataGridView1.Rows[i].Cells["Column4"].Value + ", " + dataGridView1.Rows[i].Cells["Column5"].Value + ");"; That would then be my query. I can't see a 16 anywhere in my query code. No clue whats going on. I've been playing around with this now for about a week. I'm like 90% finished with the program lol. If anyway can help would be awesome. -- View this message in context: http://sqlite.1065341.n5.nabble.com/SQLite-error-near-16-syntax-error-tp6708 6.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
