TBetterADODataSet - Row handle referred to a deleted row or a row marked for deletion

From: Matthew Noordermeer (s4054890_at_student.uq.edu.au)
Date: 12/26/03 

Date: Fri, 26 Dec 2003 18:56:07 +1000

I am trying to use 2 x TBetterADODataSet to define a master-detail
relationship (D7, SQLServer 2000). However, I get the above error whenever
I post a new record. In the detail TBetterADODataSet I have the following
settings -

CursorLocation clUseClient
CursorType ctStatic
Update_Criteria adCriteriaKey

ResyncAutoIncrement is set to true, and the TAutoIncField.AutoGenerateValue
[primary key is an autoincrement IDENTITY field] is set to arAutoInc.

I can get it to post OK if I use a Resync_Command but then it doesn't allow
deletion. I have searched www.tamaracka.com and tried most suggestions. Any
ideas or suggestions would be gratefully received [wasted 2 days on this!]

Regards

Mike