Hi, Ulises.
That problem is related to not having a proper primary key to perform the update on.
If you're marking as updatable AND key the field you are changing, I believe that you have a problem there. Select another field (one you're not changing) as the primary key. Indeed, take a look and try to realize which is your primary key. If you don't have any fields (or field group) that you can rely on as unique, then you'll have to add one.
Just in case you're interested: hay un foro de VFP en Español que puedes seleccionar en tu Account Setup. También la interfaz completa de Universal Thread puede ser utilizada en castellano, en la misma serie de configuraciones.
Best luck,
>I need help with this:
>I have a grid based on a view using two tables.
>I use a view because I need one field to be updatable.
>Sometimes, when I try to update more than one rows in the grid, it allows me, and sometimes I got an 'Update confilct' message.
>I've been struggling with this for 3 days.
>I haven't been able to find a pattern as to when this error occurs.
>It almost seems random.
>My view UPDATE CRITERIA is set as follows:
>In the field list, only the field I need updatable is marked with
>the key and pencil marks.
>Send SQL Updates: checked ON
>SQL WHERE clause includes: Key and modified fields
>Update using: SQL UPDATE
>
>Please be as specific as possible
>Any comments will be greately appreciated
>
>TIA for your time
>
>Ulises