NamCit
asked on
How to function "SEEK" of TADOTable
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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