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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only