Is "location" *really* the unique, primary key (ID) field in the backend data source? I ask because '_id' in a field is usually what we (geek programmers < s >) call our key fields.

Can you change the date field and not receive the error?

>>-What field do you change the letter in?
>The field name is "doc_id"

>>-What fields do you have marked as updateable on the Update Criteria tab in the view designer?
>I have "doc_id" and "date" set as updateable
>
>>-What is your current setting for the WHERE clause? Key and Modified fields?
>Key and Modified fields
>
>>-Which field is marked in the Update Criteria tab as the key field?
>"location" is the keyed field and is not marked as updateable.
>
>The three fields mentioned are the only fields in the table.