>I have a grid populated with a view, the view using update type "SQL DELETE THEN INSERT", the grid have the delete column. if I have a view with 3 records and I delete the record that is in the middle the record is deleted and the tableupdate() is sucessed, if I delete the first and last record I have the error message "Record is out of range", I have the same problem if the recordsource property is a table. Why this happen ?
>
>Thanks
>Carla Silva
What many of us do, is handle the deletion in the DELETED method with code. Something like:
LPARAMETERS nRecNo
NoDefault
goto nRecNo
if eof()
return
endif
delete next 1
=TableUpdate(whatever_parameters_here)
ThisForm.Refresh() or This.Refresh()
Mark McCasland
Midlothian, TX USA