delphi cxgrid restrict characters

Question

We are working in Delphi 2006 with devexpress.

We have a cxGrid. We want to restrict the entry of values for a number column, integers between 0 and 999. If I set the property type to a SpinEdit the initial value is always 0 which is unwanted.

So I left the property value on the column null and set the datatype on the databinding of the column to Smallint. That works for the most part but an 'e' and '.' and '+' and '-' can still be entered into the column which causes exceptions.

Is some simple way to exclude the 'e' and '.' and '+' and '-' from being entered into the column?

Great question, Jacques :) – Stephen Oberauer Apr 19 '18 at 08:39 — Stephen Oberauer, Apr 19 '18 at 08:39

score 0 · Accepted Answer · answered May 15 '13 at 16:45

0

The initial 0 Value can be prevented by setting UseNullString to true.

The input of unwanted characters can handled by

procedure TForm1.ViewEditKeyPress(Sender: TcxCustomGridTableView; AItem: TcxCustomGridTableItem;
  AEdit: TcxCustomEdit; var Key: Char);
begin
   if AItem = TheColumnWithSpinEdit then
     if (not (Key in ['0'..'9',#8])) then Key := #0;
end;

answered May 15 '13 at 16:45

bummi

27,123
14
62
101

Thanks bummi. The UseNullString property doesnt exist on our cxgridDBColumn but I implemented your ViewEditKeyPress code on my view and that works like a charm although AItem = TheColumnWithSpinEdit never validates so I changed it to AItem.Caption = TheColumnWithSpinEdit.Caption. I also tried casting AItem as TcxGridDBColumn to no avail. Thanks again. – jmskippy May 15 '13 at 17:51

delphi cxgrid restrict characters

1 Answers1