MULTIPLE SELECTIONS IN A TRIGGER

[christian77]

Hi:

I have a trigger in a button that selects in a field. I can´t find the right Search String expression to select more than one value at a time. The field is a numeric one that takes values from 1 to 9.

I have tried several ways:

7,8

‘7’,’8’

=’7’,’8’

={‘7’,’8’}

It doesn’t work.

Can anyone help me?

Thanks.

[#2 · Accepted solution]

Hello Christian,

if the field is num and you want to select 7 and 8 try this as search mask of the trigger:

(7|8)

regards, Roland

[kaushiknsolanki]

Hi,

   Type in this fasion.

   (7|8)

Regards,

Kaushik Solanki

[raghavsurya]

Hi,

Try putting it as (7|8)

Regards,

Raghav

[christian77]

Thank you all !!!!!!!!!!

It works perfectly.

I've choosen as correct the first one but they are all correct.

[subin6600]

Hi if the field value is a text how can the selections be made??I need 4 options to be select like say , ABC, BCD,CDE,EFG

[subin6600]

any one who is trying to get the syntax??Plz its urgent..

[#8]

Hi Ronald Kunle,

                    Could you please let me know how to get the symbol that is being used between the numbers 7 and 8..

Thanks,

Lavanya

[#9]

Hi Lavanya,

this is the pipe-symbol "|" (=chr(124))

RR

[#10]

If field value is a string, you can use that:

'ABC|BCD|CDE|EFG'

Regards