by cjm » 28 May 2014 20:20
I am setting the date column as follows:
GridCol.Editable := True;
GridCol.Formatter := gcfDate;
GridCol.EditOptions.DatePickerOptions.Disabled:= False;
GridCol.FormatOptionsDate.NewFormatDelphi := 'mm/dd/yyyy';
Getting the following error when the date is left empty:
error Status: '500: '''' is not a valid date and time'. Error code: 500
I am setting the numeric column as follows:
GridCol.Editable := True;
GridCol.Formatter := gcfNumber;
Getting the following error when it is left empty:
error Status: '500: '' is not a valid floating point value'. Error code: 500
The editing seems to work and save values as long as values are entered and they are not left empty. The users need to be able to leave the date fields empty when they do not have a date to enter. It should save a Null value when a date is not entered. I will write my own form for editing if I can not get this work but would appreciate any help you can give.
Thank You