Solved

How to function "SEEK" of TADOTable

Posted on 2002-07-10
2
624 Views
Last Modified: 2012-06-22
Dear All Advisor !

When i use function "seek" of ADOTable, i get the error "

"Object or Provider is not capable of performing requested operation"


How will i set the value of Table's property. I have already created index on table. And i also set ADOTABLe's Indexname  With the name of index field

I suppose that function SEEK will be more faster than Function Locate. IS that true. Now, i use function locate. But it is still fast.

Thank for all
0
Comment
Question by:NamCit
2 Comments
 
LVL 22

Accepted Solution

by:
mnasman earned 20 total points
ID: 7145254
Hello

>>  I suppose that function SEEK will be more faster than Function Locate. IS that true

No, it's not true, Locate is smart, when there's an index it will use it, and if there's no index, it will perform the normal search method

Best regards
0
 

Author Comment

by:NamCit
ID: 7145569


Now, i use ADOQuery to find a ID, but i should write more code lines to do it than using "Locate" function.

I use TADOQuery to excecute a SQL Statement. I do not use TADOCommand , TADODataSet. Because i do not know the Strength of them.

Please make the comperasion between TADOQuery and TADOCommand, TADODataSet




0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

This article explains how to create forms/units independent of other forms/units object names in a delphi project. Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
In my programming career I have only very rarely run into situations where operator overloading would be of any use in my work.  Normally those situations involved math with either overly large numbers (hundreds of thousands of digits or accuracy re…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now