>>After pressing the save button the active screen releases,
>>taking the user back to a grid from which specific records
>>are edited. When the mouse is used to move the pointer
>>off of the previously accessed record the error message
>>appears and program is cancelled.
>>Any Ideas?
>
>Please post the code that makes up the view. Is the view parameterized? Are you creating the view more than once?

The view was created using view designer. The view and base table
are contained in the form's data enviroment with the buffermodeoveride
property of each set to 1 (use forms setting which is optimistic buffering).
The following code is in the view SQL window of the view designer.

SELECT *;
FROM dixie2!players;
ORDER BY Players.last, Players.first, Players.middle

Most of the fields selected are character fields with various
lengths. There is one memo field and several logical fields.
No parameters.

This view is only used with one menu item. The first form has
the view bound to a read only grid. The user selects a record
from the grid and chooses to Edit. Another form pops up allowing
the user to edit fields of the selected record. Click() behind
Save button:

select vplayers
tableupdate()

select players
tableupdate()
thisform.release

The user is then back on the first form and the error occurs when
the record pointer is moved to another record.

The problem only occured on a couple of records. I deleted the
records and have not received the error message again, yet.


Thanks for you time.
Dave