My Visual Database — combobox.sqlvalue with multiple values without sql query?

Re: combobox.sqlvalue with multiple values without sql query?

null@example.com (tcoton) — Wed, 07 Jun 2023 22:28:38 +0000

Looks like a brilliant idea, I love configuration tables, I already use one. It does not apply to this very case but could prove useful.

Thanks Derek!!

Re: combobox.sqlvalue with multiple values without sql query?

null@example.com (derek) — Wed, 07 Jun 2023 20:41:12 +0000

Hi TCoton, Hi Sparrow,
Another option could be to take a more 'data driven' approach and use some sort of 'configuration' table to determine what gets shown / hidden, what color is selected for a panel, what text is shown etc etc depending on the value that is selected from a combobox.
It's not always suitable (depending on the type of project you are working on) but does mean that nothing is hard-coded and so can offer flexibility.
Maybe it can give you some ideas.
Derek.

Re: combobox.sqlvalue with multiple values without sql query?

null@example.com (tcoton) — Wed, 07 Jun 2023 17:52:56 +0000

Thanks Sparrow for the geek version of it, it does the same but it takes longer to write than the version from Derek

Re: combobox.sqlvalue with multiple values without sql query?

null@example.com (sparrow) — Wed, 07 Jun 2023 16:57:35 +0000

procedure Form1_ComboBox1_OnChange (Sender: TObject);
var
arr: array[0..2] of string = ['1','3','5'];
i: integer;
begin
  for i := 0 to length(arr) - 1 do
    if form1.ComboBox1.sqlValue = arr[i] then
    begin
    form1.panel1.color := clpurple;
    break;
    end else form1.panel1.color := clBtnFace;
end;

Re: combobox.sqlvalue with multiple values without sql query?

null@example.com (tcoton) — Wed, 07 Jun 2023 16:21:06 +0000

That's it, thanks Derek.

So, the object.SqlValue property can only accept a unique value but it is good to see that we can place a "or" in between them one way or another!

if (form1.combobox1.sqlvalue = '4') or (form1.combobox1.sqlvalue = '5') then form1.panel1.color := clpurple;

Re: combobox.sqlvalue with multiple values without sql query?

null@example.com (derek) — Wed, 07 Jun 2023 15:58:48 +0000

Hi,
So, something like this?
Derek.

Re: combobox.sqlvalue with multiple values without sql query?

null@example.com (tcoton) — Wed, 07 Jun 2023 13:48:23 +0000

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;

Re: combobox.sqlvalue with multiple values without sql query?

null@example.com (derek) — Tue, 06 Jun 2023 23:24:08 +0000

Hi,
Would using the combobox 'multi-select' option give you what you want?
Derek.

Re: combobox.sqlvalue with multiple values without sql query?

null@example.com (tcoton) — Tue, 06 Jun 2023 22:09:00 +0000

That is not exactly what I am looking for, this is data aggregation within a combobox.
I am writing a script to check if a combobox sqlvalue is either X or Y to change its display according to what is found. I know I can write a sql query to get the "sqlvalue in the range I want but I was wondering if the "SqlValue" property could retrieve multiple values or if it is always a unique value.

Re: combobox.sqlvalue with multiple values without sql query?

null@example.com (pavlenko.vladimir.v) — Tue, 06 Jun 2023 21:47:49 +0000

...

combobox.sqlvalue with multiple values without sql query?

null@example.com (tcoton) — Tue, 06 Jun 2023 21:08:06 +0000

Does anyone knows if it is possible to retrieve multiple values for the property "SqlValue" of a combobox like so or do I have to write an SQL query?

Possible or not? I already know this syntax does not work but I cannot find any documentation about this property:

if Form.Statuslist.sqlValue in ('2', '13') then .... do something