Topic: 2 columms intenger
columm1 / columm2
if columm1 <=1 columm2 = yes // 1+
if columm1 >=0 columm2= no // 0-
please help me make this work.
My Visual Database → Script → 2 columms intenger
columm1 / columm2
if columm1 <=1 columm2 = yes // 1+
if columm1 >=0 columm2= no // 0-
please help me make this work.
begin
if Form1.TableGrid1.Cells[1,i] = '1' then Form1.TableGrid1.CellS[2,i].Text := YES;
if Form1.TableGrid1.Cells[1,i] = '0' then Form1.TableGrid1.CellS[2,i].Text := NO;
end;
im try like this but dont work
You should use event OnChage of Tablegrid
procedure Form1_TableGrid1_OnChange (Sender: TObject);
begin
...
if Form1.TableGrid1.Cells[1,i] = '1' then Form1.TableGrid1.CellS[2,i] := 'YES';
if Form1.TableGrid1.Cells[1,i] = '0' then Form1.TableGrid1.CellS[2,i] := 'NO';
...
end;
But maybe better if you use calculated field for that
if Form1.TableGrid1.Cells[1,i] < 1 then Form1.TableGrid1.CellS[2,i] := 'YES';
if Form1.TableGrid1.Cells[1,i] > 0 then Form1.TableGrid1.CellS[2,i] := 'NO';
help me convert this into a calculated field please
(CASE
WHEN columm1 <= 1 THEN 'Yes'
WHEN columm1 >= 0 THEN 'No'
END)
Possible column calculated with combobox filter?
(CASE
WHEN columm1 <= 1 THEN 'Yes'
WHEN columm1 >= 0 THEN 'No'
END)
need to place a combobox search on this calculated column without repeating equal values
My Visual Database → Script → 2 columms intenger
Powered by PunBB, supported by Informer Technologies, Inc.
Theme Hydrogen by Kushi