>>Thanks arnon, you are right, that works if you know in anticipation the condition for the SQL statement, but what happen if the condition gets complicated like:
>>(cat_code=1 and item_Code=3) and (cat_code=2 or item_code=1)
>>and actually I let the user to construct any condition he wants.
>then u do the same only use macro substitution to construct
>the critiria
>
>Arnon
Thanks arnold, and to all of you that have help with this,I think I finally find it and I think is going to work.
The macro substitution how you say I don't think works here, because how a toll you at the beginning the whole criteria should find the records that match the statement in just one field. What I have in mind is to split the SQL statement in pieces and then submit as many SQLs as I need and then
add everything, got it ?.
Anyway thanks a lot.