Hi Jeff --

The part of this whole exchange that blows me away is that a TABLEUPDATE deletes the record from your view. Besides that, the Update Conflict could be caused by a NULL or invalid value in a column (field). Look over your back-end table structure. Also, are there any sequences defined for any columns in the Oracle tables? If you try to update those fields, ka-blam.

>Changed to just key fields. changed to table buffering. Now I can change the record with out it giving me an error. I issue the tableupdate() and it deletes the record from my view. Tableupdate() returns true. Requery() show the data before I changed it.
>
>Thanks for your help but I think that I am going to call it a day. I will work on this more tomorrow.