🚀 go-pugleaf

Master-detail uses Filter that is not available on client-side cursor. So
you should either use server-side cursor or master-detail. You may try
execute "SELECT * FROM .. WHERE .." every time you need details.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi + ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

"Palmetzhofer Dietmar" <dietmar.palmetzhofer@boku.ac.at> �������/�������� �
�������� ���������: news:3fca2387@newsgroups.borland.com...
> This really speeds up my application. But I encountered another problem
now:
> When I am trying to insert a record in a detail-table (from a
master/detail
> relationship), I get the error: "<Fieldname> can not be changed. Is it not
> possible to use master/detail-relationships when using ServerSide cursor?
> Thanks,
> Didi
>
>
> "Viatcheslav V. Vassiliev" <support@oledbdirect.com> schrieb im
Newsbeitrag
> news:3fc9b250@newsgroups.borland.com...
> > Use server-side cursor - CursorLocation = clUseServer and TableDirect =
> > true. Call DisableControls()\EnableControls() even if you have no
controls
> > attached. If you need extreme speed, try OLEDB Direct at
> > http://www.oledbdirect.com
> >
> > file://------------------------------------------
> > Regards,
> > Vassiliev V. V.
> > http://www.managed-vcl.com - using .Net objects in Delphi + ADO.Net
> > http://www.oledbdirect.com - The fastest way to access MS SQL Server,
> > MS Jet (Access) and Interbase (through OLEDB)
> >
> > "Palmetzhofer Dietmar" <dietmar.palmetzhofer@boku.ac.at>
�������/��������
> �
> > �������� ���������: news:3fc8a70e@newsgroups.borland.com...
> > > I have to insert (or update) lots of datasets in a Access-2000 DB, and
> > this
> > > takes a LOT of time. I am doing this by using
> > > TTable1->Append();
> > > // set the fieldvalues
> > > TTable1->Post();
> > > in a loop. Does anyone know if there is a possibility to use a
batch-job
> > for
> > > this (i.e. inserting the records in a buffer and posting them in one
> > step)?
> > >
> > > Can somebody explain to me, what the different Execute-Options mean?
The
> > > explanation in the helpfile is not very helpfull for me ...
> > >
> > > Thank,
> > > Didi
> > >
> > >
> >
> >
> >
>
>