[peyton]

Hi,

I have this variable


when I update the table it gives an error

here is my update code
Code:

str= "UPDATE tblnames SET Name = '" & name & "' WHERE Id ='" & getid & "'"

can someone tell me what’s wrong with it because the name variable has a comma in it

Thanks
Peyton

[Minakshi]

Hi,
Check the declaration of the name variable. Something might be wrong there only. Have you enclosed it in quotes while declaring it in your code? The statement otherwise looks fine.

[Tom Tom]

The syntax for UPDATE is

UPDATE <table name>
SET <column> = <value> [,<column> = <value>]
[FROM <source table(s)>]
[WHERE <restrictive condition>]

str= "UPDATE tblnames SET Name = '" & name & "' WHERE Id ='" & getid & "'"

This looks ok but, but i am not sure about your ID, is this a string or a numeric value?