I added a word-index on order-line table for field cust-po.
I used something like : for each order-line where order-line.cust-no matches "*" + cust-po# + "*"
Now i use : for each order-line where cust-po contains cust-po# + "*"
The problem i have is for example if i search for po 1234 with contains command, it won't find it because the exact po is 16-1234. The matches worked but the contains searches a string that BEGIN with 1234 so the result is false.
I wish to use the word-index because it's a lot faster !
Do someone has a solution with the contains command ?
Thanks in advance !
I used something like : for each order-line where order-line.cust-no matches "*" + cust-po# + "*"
Now i use : for each order-line where cust-po contains cust-po# + "*"
The problem i have is for example if i search for po 1234 with contains command, it won't find it because the exact po is 16-1234. The matches worked but the contains searches a string that BEGIN with 1234 so the result is false.
I wish to use the word-index because it's a lot faster !
Do someone has a solution with the contains command ?
Thanks in advance !