🚀 go-pugleaf

Master-details relationship in ADO is supported by MS Shape provider. It
works with other providers and requires client-side cursor. Most (if not
all) other providers do not support master-detail. Sorting and filtering is
not supported by most providers too. So, the only one way to use
master-detail is to do it manually - open a master dataset and, every time
you move requery your detail dataset.

Regards,
Vassiliev V.V.
http://www.oledbdirect.com

"Tony" <hse@hill-soft.com> �������/�������� � �������� ���������:
news:3cc2f644_2@dnews...
> 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.
>
>