Field calculating NULL into a field of an RCE attribute table

Question

I am trying to field calculate NULL into a field of an RCE attribute table but am receiving the following error message: "Unable to save changes.  Detail: Specified cast is not valid."  Has anyone else received this error message and/or know how to correct it?

AmitHazra · Answer

I've tested Event Editor 10.6.1 where an attribute that has a value other than has been populated via an edit. I then used the selection tools in Event Editor to open the results grid and field calculate the edited attributes back to simply by not filling in the value with anything and clicking OK. Is that the workflow you have implemented? What release of Event Editor are you currently operating on? Amit @ Esri

NicoleHanson1 · Answer

If it's not letting you do it in RCE, I know you can do bulk updates of events in desktop R&H.  That is most often where I make large changes to events.

JosephMonti · Answer

Yes, this field does allow for NULLs.  In fact, NULL is actually the default value for this field but one editor accidentally populated this field for multiple records, so now we are trying to change them all back to NULL.  We could change them one record at a time, but that would be very time consuming.  I am able to field calculate any of the other domain values for multiple records, so it follows that I should be able to field calculate NULL as well (NULL appears as one of the domain values).