Re: Using SEEK on a TADODataSet

From: Viatcheslav V. Vassiliev (support_at_oledbdirect.com)
Date: 08/30/04 

Date: Mon, 30 Aug 2004 19:51:28 +0400

MS SQL Server OLEDB provider does not support indeces (they are used when
preparing queries, of course, but not exposed to user). Only one MS OLEDB
provider supports them - MS Jet (MS Access).

//------------------------------------------
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)

"Brian Wheatley" <brianpw@neo.rr.com> сообщил/сообщила в новостях следующее:
news:413343d1$1@newsgroups.borland.com...
> Hello,
>
> I have an application with a TADOConnection and a TADODataSet on a data
> module form. The TADOConnection is connection to a MS SQL Server database,
> and the TADODataSet's CommandText property is as follows:
>
> SELECT * FROM CAPACITY
>
> The CAPACITY table has a primary key on a MODEL_NO field, and a secondary
> index IX_MODEL on MODEL (not MODEL_NO) and CAPACITY fields.
>
> The documentation for the SEEK method states that the index name must be
> set. However, the index names do not appear in the design environment. I
can
> type in IX_MODEL but the SEEK method still does not work. I also tried
> setting the IndexFields property to MODEL;CAPACITY but that did not work
> either.
>
> The table will open and I can edit the data using a db grid, I just can't
> get the SEEK method to work.
>
> Can anyone tell me exactly what I need to do, step by step, to use the
seek
> method?
>
> Thank you,
> Brian Wheatley
>
>
>
>

Relevant Pages

  • RE: Q: what is the relation between DB-Lib, OLE-DB, and ODBC?
    ... DB-Lib for many years. ... If you use the Microsoft SQL Server OLEDB Provider and ... native OLEDB interfaces, you can setup the command column/parameter ... believe both DB-Lib and the OLD Provider for SQL Server are implemented ...
    (microsoft.public.data.oledb)
  • Re: Parameters Question
    ... OleDB the syntax for calling a stored procedure is the same as the ODBC ... The .NET Framework Data Provider for SQL Server does not support the ... In this case, you must use named parameters, as in the ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Parameters Question
    ... Also as I said in my post, the reason I sometimes use OLEDB for both Access ... and SQL Server is so I can upsize the Access database to SQL Server and use ... Do you have an example of using named parameters with OLEDB for both Access ... It will work with question mark placeholders. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: oledbconnection v sqlconnection
    ... The OleDb provider is a one-size-fits-all data access interface that uses ... No two database engines have the same SQL so you'll have to ... actual low-level data access layer and exposes a common object layer that ... Hitchhiker's Guide to Visual Studio and SQL Server ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Access linked tables to ODBC in C++/ADO application
    ... to stay inside an actual Access OLEDB file. ... the .MDB, but are run against linked tables to the SQL Server ODBC ... I know that OLEDB is just the standard protocol, ...
    (comp.databases.ms-access)