Re: ADO Filtering and Sorting

From: Viatcheslav V. Vassiliev (support_at_oledbdirect.com)
Date: 05/21/04


Date: Fri, 21 May 2004 13:59:36 +0400

Filter and sort are available only on client-side cursor (CursorLocation :=
clUseClient).

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

"Mike Kabue" <myqro@yahoo.com> сообщил/сообщила в новостях следующее:
news:40adaba8@newsgroups.borland.com...
> Hi,
> I have an App which i would like to sort/filter but using an TADOTable
> Object.
>
> When I try to do this, i get an error 'Current provider does not support
the
> necessary interface for sorting or filtering.'
>
> The databases is MS SQL2000 and i am developing in delphi 7 enterprise.
>
> Regards Mike
>
>



Relevant Pages

  • Re: Reading the definition of a view
    ... OpenSchema with siViews, field is VIEW_DEFINITION + siProcedures, field is ... Vassiliev V. V. ... http://www.oledbdirect.com - The fastest way to access MS SQL Server, ... MS Jet and Interbase ...
    (borland.public.delphi.database.ado)
  • Re: invalid class typecast
    ... >>Vassiliev V. V. ... >>http://www.oledbdirect.com - The fastest way to access MS SQL Server, ... >>MS Jet and Interbase ...
    (borland.public.delphi.database.ado)
  • Re: adAffectCurrent not working
    ... Regards, ... Vassiliev V. V. ... http://www.oledbdirect.com - The fastest way to access MS SQL Server, ... MS Jet and Interbase ...
    (borland.public.delphi.database.ado)
  • Re: SQL Results not the same when run in delphi
    ... Vassiliev V. V. ... http://www.oledbdirect.com - The fastest way to access MS SQL Server, ... MS Jet and Interbase ...
    (borland.public.delphi.database.ado)
  • Re: Database components
    ... Regards, ... Vassiliev V. V. ... http://www.oledbdirect.com - The fastest way to access MS SQL Server, ... MS Jet and Interbase ...
    (borland.public.delphi.thirdpartytools.general)

Loading