We are currently running 10.1 sp1. I was wondering why it is that after I remove all locks from our enterprise gdb I try to change one of our fields data type from a text to a long integer. It allows me to make the change but when I hit apply it just reverts back to its original text data type value. If I have any kind of text value in that field when I try to change to a long integer would that cause this behavior?
for example the field I want to change is "House_Num" which has its data type set to text. All the values in the field are numbers except for a couple that has text. would this cause it not to change and revert back to text after I hit apply?