execnonquery2

Hi. My first post so forgive me if you start yawning and getting angry telling me, "you should have searched this post.." I have searched 100s of threads and tried umpteen options but I'm still getting an error. I'm simply trying to INSERT into my sqlite DB (the code works fine when I commit...

Hi all, I need to update records in a database with ExecNonQuery2. But the values in the array need to be enclosed in quotes. My query: sql.ExecNonQuery2("UPDATE parts SET PartID = ? WHERE PartID = ?",Array("'" & row(1) & "'", "'" & row(0) & "'")) '<-- this doesn't work The query should look...