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"

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.

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top