🚀 go-pugleaf

Borland Builder 5
MS-SQL
ADO Express

Can anyone tell me how to use a server cursor location in a master detail
table relationship?

I have an application with a master table I will call Master and a detail
table I will call Detail. The Detail table DataSource property is set to
Master. Detail.MasterID= Master.ID. The application works fine as long as I
use client-side cursors. I need to change the detail table to server side
cursors because it will contain many (500,000 +) records and I do not want
to load these records into memory.

 I changed the Detail dataset cursor location to server and cursor type to
keyset. This caused the error "Current provider does not support necessary
interface for sorting or filtering" when the table is opened because the
IndexFieldNames property of the dataset cannot be used with a server cursor
location and this property is used in a detail table dataset to reference
the master table. In this case Master.ID

I tried changing the detail dataset to a query from a table as follows.
Select * From Detail Where MasterID = :ID. The Detail table datasource
remains set to the Master table. This allowed the Detail table open without
errors but when adding a Detail record in a form using TDBNavigator the
Detail.MasterID is no longer set to the Master.ID and remains NULL. This
relationship (Detail.MasterID = Master.ID) was maintained automatically when
the cursor location was set to Client.

I tried setting the Detail.MasterID field manually in the BeforePost event
but got the error "Multiple step OLE DB operation generated errors ...".

Thanks in advance for any advice on how to solve this problem.