This question has been flagged
1 Reply
5256 Views

I'm thinking advance in time. I'm developing a module, and there are some fields of a custom object whose type isn't really narrowed by the time. I'm using some kind of "loose" type (say, text types) for things that in the future may result to be selections or another type (the use experience will tell what's the best).

How do you manage such changes? How does OpenERP cope with making a change like this? Does any extra step need to be done for updating the database?

Avatar
Discard
Best Answer

Don't do that. You have to set your fields type before using it. I'm going to explain you why.

When you change the type of a field OpenERP automatically s going to create a new column on the database and the other column is going to be called name_moved or something like this. Even if you change between float to char.

Maybe you can make a SQL query that move all the data from the old column to the new one, but you have to do it manually.

Avatar
Discard