>>>
>>>The view has a buffermode of 5. The underlying table has a buffermode of 1.
>>
>>Do you have both the view and the underlying table open in the dataenvironment?
>
>No, I don't. I've actually tried doing this, to see if it helps, but it didn't. The only table in the first form's DE is the view.
>
>Again, the problem doesn't occur if I add _two_ records to the previously empty underlying table (via the second form), then delete them (via the first). I only get the 1585 if I add just one, then delete it.
Let me try to get this straight...
open form1 (contains view v_mytable)
form1 calls form2 (contains mytable), private DE
form2 appends a record into mytable
form2 closes (modal?)
Form1 does a REQUERY() on v_mytable
form1 deletes new record in v_mytable
form1 does a TABLEUPDATE() on v_mytable which results in an update conflict.
is this the order of things?
if not please clarify...
Erik Moore
Clientelligence