I may express myself wrongly, let me reformulate.
I have a table with ids that are associated to a status.
This status is displayed via a combobox.
According to the status displayed or chosen, a script changes something in the project, like disabling an object or checking automatically a checkbox.
Some other status could lead to the same action.
Instead of writing complex SQL queries that I can write, I want to know if I can associate multiple values to the object property "SqlValue" in the script tab like in the attached example.
In this project, selecting a color changes the panel below it. The last 2 choices should both change to purple, not red but it does not with current script.
procedure Form1_ComboBox1_OnChange (Sender: TObject);
begin
if form1.ComboBox1.sqlValue='2' then
form1.Panel1.Color:= clGreen;
if form1.ComboBox1.sqlValue='3' then
form1.Panel1.Color:= clTeal;
// I would like to combine both sqlvalue = so it would be like a sqlExecute(select status.id from status where id=4 or id=5) .... or where id in('4','5')
{if form1.ComboBox1.sqlValue='4' then // same color as below
form1.Panel1.Color:= clRed;
if form1.ComboBox1.sqlValue='5' then // same color as above
form1.Panel1.Color:= clRed; }
if form1.ComboBox1.sqlValue='4 or 5' then // either choice = same color
form1.Panel1.Color:= clPurple;
end;