>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

Hi Bonhomme,

I am not an expert, so take this with a grain of salt. Could it be that you can not do that as one statement? Maybe:

Dim sqlUpdate As String
sqlUpdate = " Update Customer " & " Set Name = ' " & Name & " ', Address = ' " & Address & "'," & " Where PhoneNo = '" & Key & "'"

HTH,
Beth