James,

> ib_query.sql.add('select id, name from supplier');
> ib_query.sqlwhereitems.add('or name like ''%hardware%" or name like
> ''%auto%" or name like ''%supply%''');
>
> I think the problems is because the first line of the sqlwhereitems have
> "or" as the first word.

Right !

ib_query.sql.add('select id, name from supplier');
ib_query.sqlwhereitems.add('name like ''%hardware%" or name like
''%auto%" or name like ''%supply%''');

But like Jason said, sqlwhereitems will affect only onPrepare !

Harald