Hi Naomi,
I only see one comma period after the address field. ?:)
>Hi Beth,
>
>He has one extra comma after the Address field. Look closer at the string.
>
>>>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