Hello wonderful people. Has anyone found a solution to the following:
In Extended Properties Maintenance, I’m trying to set the UD Code Type for Key1 field, however, as per problem PRB0210320, this is an enhancement. In most cases, I’d just create a UD field, though, in this case, it needs to be the key field.
So… any work arounds you can think of on this one?
NOTE: DO NOT DO THIS IN YOUR DATABASE. IT WAS AN EXPERIMENT!!!
For those playing along at home… Just out of interest, I tried the following:
insert into ice.ZColumnProperty(SystemCode, DataTableID, FieldName, PropertyID, SystemFlag, OverrideValue) values(‘ICE’,‘UD10’,‘Key1’,‘UDCodeType’,0,‘TIMETYPES’)
It seems to work perfectly as expected with all epimagic, but this isn’t something I can really implement as this kind of data manipulation is 100% out of bounds. Just interesting that it’s so easy to make work that it makes me wonder why it’s not been updated by epicor in over two years.
