SQL INSERT Command

tehon3299 · Feb 12, 2003

OK - Can you use a WHERE clause in an INSERT statement in SQL? If so what am I doing wrong here:

Code:

SessionCmd = "INSERT INTO tmBalance (UserBalance) VALUES (" & TotalBalance & ") WHERE UserID = " & user & ""

TotalBalance is an Integer.

Thanks!

quwiltw · Feb 12, 2003

No it looks like you want an UPDATE statement.

Code:

UPDATE tmBalance SET UserBalance= "& TotalBalance & " WHERE User=" & UserID & ""

tehon3299 · Feb 12, 2003

DUH! I cant believe I did that. Thanks a lot!