and I'm really not sure what you are trying to run, but it's different story. INSERT INTO with WHERE ?
I am using two arrays to populate a table. Arraya has values and arrayb contains the dates. I want the WHERE in the SQl string to verify arraya and arrayb are in the same row(intRow). I just want the row location of the arrays not the values in them.
This is not how you would write it?
in your case INSERT INTO inserts ONE row into table, if you want to make condition if to insert the row into table, why don't you use IF statement before the db.EXECUTE?
IF arraya <> arrayb then