Do I have a corrupted db?
About mid-day yesterday it was necessary to remove a db field from a support table to rename it. (Creator allowed me to use the reserved word "type" as a field label. Trying to access it later by script caused errors.)
This field was also being referenced by a lookup field in my main data table, so it was necessary to removed the field from that table, as well as comment out all script references to it and delete all the records from the main table.
After doing this I was able to remove the original field, add it back and rename it to "name". Then re-added the the lookup field in the main table, naming it just as I had before "status". Then un-commented all the script references and proceeded to test the results.
I am able to write to the new "status" field in the support table via the GUI and write to the lookup field in the main table via the GUI, but I am NOT able to write to the new lookup field in the main table via script. I receive a constraint error as reported in the attached screenshot.
username: t.e.sadler
app: onCalendar
access is open to support