INSERT INTO statement

  • Thread starter Thread starter Todd Schei
  • Start date Start date
T

Todd Schei

I'm trying to insert data into an existing record in my
table using "INSERT INTO"

All my values that I want to insert look fine when I
review in debug mode. The values don't show in table after
the "dbcurrent.Execute stSQL" statement. I get no
errors. Everything looks fine, except the record doesn't
change. What's wrong?
 
I'm trying to insert data into an existing record in my
table using "INSERT INTO"
Click to expand...

Wrong tool. INSERT INTO does not do this! It creates a NEW record.

Use an Update query joining the two tables instead.
 
I get no
errors. Everything looks fine, except the record doesn't
change.
Click to expand...

Like John says. And I suggest using the dbFailOnError option of the Execute
method, so if there is a problem with the SQL you get told about it.

HTH


Tim F
 
Back
Top