Finding this word "O-Ring" on Description field fr

fmhigue

I know is something simple, but I do not have an idea how to do it.

I need to block all items on the Item table, that includes "O-Ring" as part of the description because we can not import those items rightn now.
(We do not have an special document our goverment is asking us and I do not want Customer Service to quote those)

Which function do I need to use to find that text?

Thank you

Luc_VanDyck

recItem.SETFILTER(Description,'=%1','*@o-ring*');

Savatage

Does that filter OUT O-Ring?

Luc Van Dyck wrote:

recItem.SETFILTER(Description,'=%1','*@o-ring*');

I was thinking as an easy solution was creating a new field on the item card.

Call it "Temp Block" (or something) as a Boolean Type.

Check the "O-ring" items off since it's easy to select items that CONTAIN "O-ring"

Then you can easily filter items that "Temp Block" is false.

It just seems a a quick & easy way plus you might use it for other things in the future, if not it can alwyas be deleted once done, Just a thought..

Luc_VanDyck

fmhigue wrote:

I need to block all items on the Item table, that includes "O-Ring" as part of the description because we can not import those items rightn now.

He wants to block all items that contains "O-Ring".

Of course, you need to add the line:

recItem.MODIFYALL(Blocked,TRUE);

Savatage

you da man!