||Thu, 15 Oct 2020 05:08:58 +1000
In that case, you cannot control the indexes. The server does it quite
efficiently for you. If the field you search on is indexed in MariaDB,
the index will be used to return the records.
One option is to use an ADOquery with params and set the params based on
your entryfield contents.
If you post the section of code showing what you are trying to achieve
and how, I'm sure someone can help with a solution.
On 15/10/2020 04:11, Mustansir Ghor wrote:
> Dear Gaetano
> I am using MariaDB
> Gaetano Wrote:
>> On 14/10/2020 04:16, Mustansir Ghor wrote:
>>> Dear All
>>> I understand in ADOrowset indexname and findkey is not possible. But I find it the help menu that these property and method are mentioned in the ADOrowset object.
>>> I wonder why it is mentioned.
>> The ADO help is not that great indeed, some methods exist but have no
>> Help entry, and smetimes the Help entry is not explicit enough about
>> some details...
>> One possible explanation for your indexname query is that some database
>> systems don't support setting the index, e.g. MySQL has indexes but it
>> automatically determines which index to use so you cannot set an index
>> Which database type are you connecting to?