Without looking at a sql based VFE security view, first thing that comes to mind is that there is a join in there an one of those columns should *not* be updateable. that is usually what the errror message you are getting means.
If you want to post a VFEGenview.prg of the view I could take a look
>Hello,
>
>I am using VFP8 SP1, VFE 7.5 and have a SQL Server 2008 database.
>
>I have somehow broken the "Change Password" feature in my VFE Application. When I run the application and try to change the user password, I get the following error:
>
>" No key columns are specified for the update table "appusers". Use the KeyFieldList property of the cursor."
>
>I have checked the remote view and have made sure the "cuserid" field is set as the key and that all fields are marked as "update all." I also have "key and modified fields", "sql update" and "send sql updates" fields checked.
>
>Clearly, I am missing something, but I can't see it right now.
>
>Any suggestions?
>
>Thanks,
>
>TFISHER
Charles Hankey
Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy
Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.
-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin
Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.
