Hello,

thank you for this response. But how can I enforce my users not to use
* for wildcards, or how can I show my own error message window if they
do?

Thank you in advance

Pawel Silberring

--- In IBObjects@y..., Helen Borrie <helebor@t...> wrote:
> At 08:00 AM 15-08-02 +0000, you wrote:
> >Hi,
> >
> >I have an IB_Searchpanel, which contains several fields to search
for.
> >It works, until I enter wildcards in 2 fields (eg. Name = Smith*,
> >Nickname = x*). Then I get a 'Dynamic SQL error' when I press
enter.
> >Is there a way to avoid that, or to prevent the user to enter
> >wildcards on 2 fields?
> >
> >Thank you for a hint
>
> Use the character "%" for your wildcards.
>
> Helen