>>With .NET, the sqlDataSource builder creates the Updatecommand as thus
>>
>>UpdateCommand="UPDATE [users] SET [username] = ?, [password] = ?, [fullname] = ?, [authlevel] = ?, [email] = ? WHERE [user_id] = ? AND [username] = ? AND [password] = ? AND [fullname] = ? AND [authlevel] = ? AND [email] = ?" >
>>
>>
>>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.