Good Afternoon,

We are in BaaN 5c.
In the before.program i have on the main table tcmcs052

query.extend.where("tcmcs052.dsca like "".*TEXTI.*""")

This works very well.

How can i have the same result when i want to put .*TEXTI.* in a variable?

Thank You

John

Always search the forum - this thread (http://www.baanboard.com/baanboard/showthread.php?t=27861&highlight=like+query+extend) has some examples on how you can build your query.extend.

Good Morning,

Thank you for your reply Mark.
But the problem persists.

Main Table is tcmcs052 (Projects in BaaN 5c)
Field tcmcs052.dsca with domain tcdsca
Variable card2 with domain tcdsca
the value of card2 is .*TEXTIL.*
Can you tell me how to code in the
before.program:
query.extend.where("tcmcs052.dsca like :card2") ??
or
query.extension="tcmcs052.dsca like :card2" ??

I tried quite some coding but none of them work.

Kind Regards

John

You can do this:

query.extend.where("tcmcs052.dsca like """ & card2 & """")

Thank you for your reply Jaap

i get


: Error: '&' not expected.

now in

query.extend.where("tcmcs052.dsca like """ & card2 & """")

Kind Regards

John

For me this compiles correctly.

Good Morning Jaap,

You were right, it compiles correctly and it works!!

Thank You very much

John