This is just a heads up for anyone writing external functions which will get called in a trigger.

I had an error

---------------------------
Debugger Exception Notification
---------------------------
Project TfRutils.exe raised exception class EEDBException with message 'ElevateDB Error #1011
An error occurred with the value +86 769 831 880 45 Ext165
(The value would result in truncation)'.
---------------------------
Break Continue Help
---------------------------

Since I was using a table component to enter the data, and table components still truncate, this baffled me until after much swearing and calling Tim nasty names I remembered I'd recently installed a trigger which was firing and generating the error. I've asked Tim to put delimiters around the value (field length was 25) so that a trailing space can be spotted but my suggestion to anyone writing triggers which update string fields is that a length check, truncation is built in. I have, and intend (subject to memory lapses) to continue to do so.


Roy Lambert