Redefining Key Field (AREV Specific)
At 04 NOV 1997 06:23:54PM Brad Clawson wrote:
I need to change the width of the key field. When I attempt to change it in the dictionary editor or in MAKETABLE I get a message that the field cannot be changed.
Is there a way to change the key field width short of creating a mirror application and exporting the data into it?
At 09 NOV 1997 01:34PM Aaron Kaplan wrote:
You should be able to DICT FILE KEY from TCL and change the display length.
Is there another width you could be talking about?
apk@sprezzatura.com
At 11 NOV 1997 10:39PM Brad Clawson wrote:
Aaron,
Thanks for our reply.
The collumn that I am trying to change is the key field. When I try to change either the validation patern from 4N to 5N or change the display length form 4 to 5 I get the following error message: The "PROJECT_NUMBER" column may not be modified.
The only things I can think to do is to either EDIT DICT KEY and change the validation patern and the display length in the dict file directly, then rebuild all my indexes or to copy the table structure to a new table with out the data, change the key field characteristics, then write an RBasic routine to move the data over.
Is either approach feasible? What are the conserns for each? Is there a better way.