>>>>With .NET, the sqlDataSource builder creates the Updatecommand as thus
>>>>which doesn't seem to work with a VFP table. In this example user_id is the key field defined as an integer. The datasource is being used in combination with a formview. Triggering the update produces an error that says the Column '' (single quotes) cannot be found.
>>>>
>>>>Can someone advise what is needed here?
>>>>Thanks
>>>
>>>As Naomi suggested remove all square brackets. VFP can't understand them. Also if user_id is a true ID field remove all other fields from where clause. There is no need of them.
>>
>>Thanks Naomi and Borislav. That does the trick.
>
>Glad you got it working.
>
>I, on the other hand, completely messed up :( I can not make something simple to work and I spent two days on it already :(

Don't feel bad. I spent all of yesterday on a half line of code. :)