🚀 go-pugleaf

Presumably at the end of the day its performing some SQL in the background
similar to...
i.e WHERE MYFIELD LIKE 'ADO%'
the % after the "ADO" means it will match anything starting with "ADO"

Use the following SQL instead - of the form
WHERE MYFIELD LIKE '%ADO%'
then it will match anything with "ADO" anywhere in the text.

"Formentz" <francesco@leotron.com> wrote in message
news:3c95c71a$1_1@dnews...
> Hi all,
> in the locate method of TADOQuery you can specify in the TLocateOptions
the
> flag loPartialKey, but the partial key is not as I expected.
> If I have a string like "use ADO instead of ODBC", if I Locate "ADO" it
> doesn't find the record, it finds the record if I search "use ADO".
>
> Is there a method to search the way I need? or a workaround? or a change
to
> the original Locate function to use it in a derived component?
>
> TIA
>
> Ciao
> Formentz
>
>