Perhaps you have some constraints defined on the SQL side that are causing this weird behavior. I dunno but it sounds like it's time to check your database schema on the server side really carefully.


>**Check the UpdateType property for the view with DBGETPROP(). It sounds like it is set to 2, which is delete and insert. You want it to be 1. **
>
>It was set to 1 (update) but with that setting I started getting the weird behaviour I described (SQL 7.0 seemed to be doing a delete and insert but only the delete was being 'saved' -- If I used row buffering Update Conflict errors started to occur also). When I changed the setting to insert and delete I could get it to work in table buffer mode. Some views worked with update, others seem to require delete/insert -- very strange! As I said before the update settings have worked fine (for the past couple of years) in sql 6.5, Oracle and VFP data, but is failing (with some views) in sql 7.0 -- any ideas?
>
>Kevin