Need Help How To Update Db

I have a prob in updateing my db
I tried :

DbCon.Execute " update tbl1 set (fname = '" & FnameTxt & "' , lname = '" & LnameTxt & "' , dateofbirth = '" & DateofbirthTxt & "' , where id = '" & IdTxt & "')"

but it dosent work for a reason

Thnks in advance 4 your help ...

J5

Missing semocolon at the end of the statement

Code:

---

DbCon.Execute "update tbl1 set fname = '" & FnameTxt & "', lname = '" & LnameTxt & "', dateofbirth = '" & DateofbirthTxt & "', where id = '" & IdTxt & "'"

---

should be like this...

Code:

---

DbCon.Execute "update tbl1 set fname = '" & FnameTxt & "', lname = '" & LnameTxt & "', dateofbirth = '" & DateofbirthTxt & "', where id = '" & IdTxt & "';"

---

[Edited by Chris on 06-11-2000 at 02:50 PM]

Well Chris 10x 4 your help
But it dosent work i dont know
why ...

But again 10x

Standard SQL (you can include theJet Update statement, too) doesn't use paren's after the set command. Have you tried:

DbCon.Execute "update tbl1 set fname = '" & FnameTxt & "', lname = '" & LnameTxt & "', dateofbirth = '" & DateofbirthTxt & "', where id = '" & IdTxt & "'"

Quote:

---

Originally posted by Jony5
Well Chris 10x 4 your help
But it dosent work i dont know
why ...

---

BTW, may i know the datatype in each fields?

Well all the fileds is text
expet the last one that he is a date

but i dont care to take him as a string
and later on i`ll fix it

It have extra comma before the WHERE Clause,

Code:

---

DbCon.Execute "update tbl1 set fname = '" & FnameTxt & "', lname = '" & LnameTxt & "', dateofbirth = '" & DateofbirthTxt & "', where id = '" & IdTxt & "';"

---

should be like this...

Code:

---

DbCon.Execute "UPDATE tbl1 SET fname = '" & FnameTxt & "', lname = '" & LnameTxt & "', dateofbirth = '" & DateofbirthTxt & "' WHERE id = '" & IdTxt & "';"

---