Kbase 17855: Roundtable- changing the datatype of a field object.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/05/1998 |
|
Roundtable- changing the datatype of a field object.
Problem:
You have created a field object in Roundtable of a certain datatype.
For this example, it is of type char. You give it a specific name.
Later, you realize that you really wanted a field object of type int.
Many people assume that the way to fix this is by deleting the old
(char) field object, and then create a new field object of the correct
type (int). However, when they try add that new field object with the
same specific name that the old object had used, they are notified
that the object already exists. This is because of Roundtable's
version control protection. When you delete an object, you are really
only deleting the reference to that object, the actual object remains
forever.
Question:
How then does one change the datatype of a field object without having
to give the new field a different name than the old field?
Solution:
In this case, deleting a field object of one type and then creating
another one with the same name, but as a different type is synonymous
to taking the original field (char) and changing it to the new
datatype (int).
If you have already 'deleted' the original field, you can do the
following:
1. Re-assign the original field that was deleted from the workspace
back into the workspace (remember, you didn't delete the field,
you just deleted the assignment of the field from the workspace).
2. Then, right click on the field tab folder.
3. Choose "change datatype or extent" from the popup menu.
4. Change the field to whatever datatype you wish.
5. REMEMBER to assign the field to a table when you are done changing
it!
If you havn't deleted the original field object, follow steps two
through five.
04/16/98 FS
Progress Software Technical Support Note # 17855