Zeoslib Portal

what is the best way to work with "in" statement, and zeos query?

example:
...
query.sql.add('where fieldname in (:field) ');
query.parambyname('field').AsIDontKnow := MaybeArray;

I currently have to concatenate the string, to do this...
is there a more elegant way than simply having to concatenate strings?

and excuse me if I say any bullshit...

francisco,

don't know which provider you're using.. You could also try to use parameters '.... in [:P1, :P2......]. IF your changing your SQL all pareters are cleared and reassigned so you have a floating param-count. String-Concatation forces Zeos always to prepare a new stmt which leads to performance loss.

Michael