07-21-2015 08:56 AM
When I try to increase a decimal field in Opportunities from 8 to 10 decimal places, it tells me I can't increase field length because the combined length of the fields exceeds the limit for the database table. However I downsized one of my fields from 450 to 120 characters and it still won't let me increase any other field.
I read this article but I don't want to delete any of my fields. Unfortunately they're all necessary.
07-21-2015 09:22 AM
The field that you decreased the size of was likely in a different table from the one where you are trying to increase the field size. SQL limits the size of individual tables but a base table can have one or more spillover tables linked to it and appear to the user as a single table. However the fields in a table, base or spillover won't bridge from table to table.
07-21-2015 12:52 PM