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
