SQL integer variable

Question

I'm making this UPDATE string for my acces 2007 database using excel

conn.Execute ("UPDATE newEmployees Set Firstname = 'testname1' Where Id = sID;")

sID is a number, but when I use it like this or like " & sID & " I get an error. On the other hand if I just write a number Where Id = 46 - It works just fine.

So my question is, how do I make an update string in SQL with a number variable?

Tim Williams · Accepted Answer · 2013-10-30 23:11:28Z

2

conn.Execute ("UPDATE newEmployees Set Firstname = 'testname1' Where Id=" & sID)

answered Oct 30, 2013 at 23:11

Tim Williams

169k8 gold badges104 silver badges143 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL integer variable

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related