You might also check to be sure that STATICDB is off.
On Thursday, October 2, 2014 7:30 PM, Lin MacDonald <[email protected]> wrote: Got it! thanks! Lin On Thu, Oct 2, 2014, at 03:36 PM, Buddy Walker wrote: Don’t delete the column. Just rename it. What I did was just add something to end like 99 then change the data type to real. Save the table without check. Do each table with the column you want to change the data type. Keep in mind after the first column you rename with the 99 will automatically change to real once you add the 99 to column name. Once done rename the column back to the original name by removing the 99. One more suggestion make sure you have a good back up and no one else has the database open. > > > >Make sure you check any views you may have created. > > > > > > > >From:[email protected] [mailto:[email protected]] On Behalf Of Lin MacDonald >Sent: Thursday, October 02, 2014 6:12 PM >To: RBASE-L Mailing List >Subject: [RBASE-L] - RE: changing a datatype > > >I do. So, do I need to delete it from all tables that have it, change the >type and then add it back in? > > > >Lin > > > > > >On Thu, Oct 2, 2014, at 02:50 PM, Dan Goldberg wrote: > >Check to see if you have that column in other tables. >> >> >> >>R> >> >>Lis column columnname >> >> >> >>You might not be seeing the error message because error messages might be >>turned off. >> >> >> >>Dan Goldberg >> >> >> >>From:[email protected] [mailto:[email protected]] On Behalf Of Lin MacDonald >>Sent: Thursday, October 02, 2014 2:48 PM >>To: RBASE-L Mailing List >>Subject: [RBASE-L] - changing a datatype >> >> >>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 >> >> >> > >
