Ryan Nilsson-Harding wrote:

>
> Hi there,
>
> I'm not sure if this is obvious or not.
> I have SeekNearest = True, but when seeking, it does not treat 'M'
> and 'm' as the same (I'm aware they're not the same, BTW).
> So if I have only one supplier, say 'Marvin' and I type in 'm', it
> does not locate Marvin.
>
> Is there a way to make this locate case-insensitive?

Create a separate field in the table that is all uppercase and update it in BeforeUpdate
and BeforeInsert Triggers.

In IBObjects specify that the field to use is the uppercase field when searching.

This is explained in the User Guide (about $30).
--
Raymond Kennington
Programming Solutions
W2W Team B