>Hi everyone,
>
>I am a Visual Foxpro programmer trying to migrate to VB.NET I find it really nice way to program but I want to update a table with this statement :
>
>Dim sqlUpdate As String = " Update Customer " & " Set Name = ' " & Name & " ', Address = ' " & Address & "'," & " Where PhoneNo = '" & Key & "'"
>
>I received and UPDATE statement error
>
>Any help please
>
>B.Sanon
You have one extra comma at the end. Remove it.
Dim sqlUpdate As String = " Update Customer " & " Set Name = ' " & Name & " ', Address = ' " & Address & "'" & " Where PhoneNo = '" & Key & "'"
If it's not broken, fix it until it is.
My Blog