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