I have a Master/Detail Form. In the detail form
I only display a subset of the elements from the
database table associated with the detail record(s).
One of the fields is a select for which
I have onChange and onClick Ajax events associated.
Based on the user selection I wish to set mulitple
database fields, some that are displayed and some that
are not. If I call these two fields vis (for visible/
displayed in the form) and invis for (invisible/not
displayed). And I give them values inside the Ajax Event:
{vis} = “value_1”;
{invis} = “value_2”;
The field vis is properly updated on the screen
immediately (and the database when the record is saved).
But the field invis is not updated in the db. When I put
debug mode on I can see that the insert/update sql statement
does NOT contain the field invis in it.
Just to make sure I checked and if I store a value
in invis in onBeforeInsert/onBeforeUpdate the field invis
is in the sql statement.
Is this an SC bug or should I not expect an (invisible)
field assigned a value inside of an Ajax Event to be
updated when the record is updated?
I can obviously add code to (re-query the database) the afterInsert/afterUpdate but
it would be nice since I already have the data in the Ajax Event.