Dear Baan Friends

I get complie error for the statement

tfgld106.leac in (:leac1, :leac2, :leac3)

where the leac1, 2 3 are form fields

so what is the problem Please help

Regards
Umesh

The IN operator allows only constants in (..).
Sorry, isn't possible to use variables.

If the requirement is mandatory , then dynamic query is the only way out . Else use OR conditions (in case of tfgld102/6 i believe there is an index also on leac ) .