I think you misunderstood that a bit. Try

::SQL::PRODID IN (SELECT PRODID FROM FORNECPROD)

Set

At 11:09 24.01.2001 -0000, you wrote:

>I'm trying on Filter in property IB_Query:
>PRODID IN (::SELECT PRODID FROM FORNECPROD::)
>but show me a message error with "-104 Token Known SELECT".
>I'm using D5, IB6, IBO3.6Ce
>
>Because?
>
>A document release to 3.6Ce say:
>"...I fixed various glitches in the Filter parsing routines. I also
>added the ability to preface the Filter with ::SQL:: so that all
>parsing will be bypassed and the text will be sent to the server
>directly as SQL in the WHERE clause ..."
>
>Tank's
>
>
>
>
>