Hello everybody;

I am a beginning in this group. My english is very poor (I'm brasilian) . So I give to you the best Regards and just begin sendind a litle question: -->>

In my codes, I have, sevarals poits that uses SQL expressions like this: 'select xxx from TABLE T where :STATUSES like '%,' || T.STATUS || ',%'. In no long past, this code solves the problem of passing a set of values to a query, to be used in place of an IN clause, for example:

select apptno from appointments
where status in (:statuses);

This ("...where :STATUSES like '%,' || T.STATUS || ',%'...") work fine, but at now, I don't know wy, it stops to work.

I did an upgrade of my Firebird to the version 1.0 and using it now.
Have a local net with Linux server (lastest Red Hat equivalent).
Access this server with Win98 clients.

So, this is what a want to know:

Dind't my code work any more?
There are something I can do?

I'm very Thanks.




[Non-text portions of this message have been removed]