Update SQL statement - HELP!!

Hi

Can someone point out what the syntax error is in the following SQL statement

SQL1 = "Update USER_DTLS Set (User_Name, Full_Name, User_Pwd, User_Description)=('" & Uname & "','" & Fname & "','" & Pwd & "','" & Udescrpt & "') where User_Name ='" & Uname & "'"

When it come's to the cmd execution it saya there's a syntax error

Thanks for your help
Viji

Try:


SQL1 = "Update USER_DTLS set User_Name = '" & uname & _
"', Full_Name = '" & fname & _
"', User_Pwd = '" & pwd & _
"', User_Description = '" & Udescrpt & _
"' where User_Name ='" & Uname & "'"





HTH,
Duncan

-------------------------------------------------
Ex. Datis: Duncan Jones
Merrion Computing Ltd
http://www.merrioncomputing.com

Hi Viji (at BJA ??)

If you have not got the answer to this yet. I can see the problem.

Martin

Thanks
Martin Clark