There was a post earlier with this problem. There are two solutions that
are commonly used.
1. unload the structure into a file and change it in there with your
text editor (tedious and error prone, I think)
2. Find out where all the columns are that have the name and data type
LIST COLUMN xyz
3. One by one, Change them from XYZ INTEGER to XYZ2 REAL
4. When they have all been changed, rename the column
Albert
On 10/2/2014 3:47 PM, Lin MacDonald wrote:
I have a column in a table that is datatype integer. I'd like to
change it to Real. I have been trying to do it through Explorer but
it won't save after I have made the change. So, I assume it doesn't
want to do it for some reason. I have removed my test data from the
table.
Can anyone enlighten me as to what I am doing wrong?
thanks,
Lin
