Error message when saving calculated custom field definition
Symptoms
When defining a custom number field with a calculation formula, an error message pops up when the field definition is saved. The syntax of the formula has been verified and it is correct.
Error/warning messages
The formula contained illegal characters or syntax is not correct
Resolution
- The stored procedure must be already in the database. It’s not possible to prepare the field definition when the stored proc is not yet there.
- The stored procedure must be accessible (grant to CPACCESS)
- The stored procedure must be able to cope with '{00000000-0000-0000-0000-000000000000}' or NULL as @entityID parameter That is how it is called to check if it’s there an accessible and working.