Hi everyone,
I am experiencing a strange bug related to date fields. I have a date field which is
Data type: date
Default: <%%creationDate%%>
Read Only box is checked...
The problem is that every time we go in and edit the record and click Save, the date field changes to today's date. It seems AppGini is mixing up created date with edited date. I've check all our settings 10 times but I cant seem to fix this. Has anyone seen this or does anyone have any advice on how I might fix this? Any advice or possible solutions are greatly appreciated.
Thank you,
Mark
date field changing on record save
Re: date field changing on record save
Hi,
I have the same problem a read-only date field.
Other read-only fields don't exist in the generated update sql, but read-only date fields do. but the value of the data array is empty.
So an read-only date field without a default has after an update of another field an null value.
My solution: a before update trigger with:
begin
set new.rms_xxxdate = old.xxxdate;
end;
I have the same problem a read-only date field.
Other read-only fields don't exist in the generated update sql, but read-only date fields do. but the value of the data array is empty.
So an read-only date field without a default has after an update of another field an null value.
My solution: a before update trigger with:
begin
set new.rms_xxxdate = old.xxxdate;
end;
Bert
I am using Appgini 5.75
I am using Appgini 5.75
-
- Posts: 10
- Joined: 2014-03-31 22:28
Re: date field changing on record save
I had this issue and had to use the <%%creationDateTime%%> set as a read only field instead of just creationdate to get it to work properly.