Does it make sense that I have a VARCHAR(MAX) field but the UI will only let me enter 6 characters? Is this some limitation? Do I have to change the varchar size in the database to fix this?
When I use the front end I’m only allowed to type 6 chars:
Yes. Where you created SpecialInstructions_c
Example:
You’ll probably need to “regenerate the data model” (or whatever it’s called in the Epicor Admin Console)
Is MAX a valid value in that field? Does it work if you set it to some big number (like 65,000)?
I dont think MAX is valid in Epicor, the front-end doesnt know how to translate that. Must use a number.
Do you know if we can just change MAX to a number and regenerate or do we have to delete the field, regen, then remake the field and regen?
Epicor by default will do x(8) so im assuming they defaulted to x(8) you should be okay changing it and regen and recycle iis again.
@smason- I looked at the Extended Properties of some builtin tables, and noticed that a Default Format isn’t always specified.
Maybe try leaving it blank
x(1000) is converted to nvarchar(max).
