Re-adding Column Already in Dictionary (OpenInsight 32-Bit)
At 05 AUG 2010 12:06:40PM Mat Kelly wrote:
I archive tables for previous years data. Each of these tables has the same column as others. One of these tables, according to Database Manager, is missing a column called, "MYDATA_CREF_XREF". In all of the correct tables, this column contains a symbolic.
In Table Builder, I attempt to add a calculated column, but when I enter the name "MYDATA_CREF_XREF", I am told that "MYDATA_CREF_XREF already exists in the dictionary."
What does this mean? How to I go about re-adding the column? What might have caused this particular table to have this discrepancy?
Thank you.
At 11 AUG 2010 04:18AM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:
MYDATA_CREF_XREF is the cross reference index for the MYDATA_CREF field. You'll need to do some of the following.
1. Check through the system editor and ensure the field is not there.
2. Delete through code (open DICT.FILE to handle, delete handle, field…)
3. Remove and rebuild all indexes on the file. (Simpler, though longer then editing the !tables by hand.)
World leaders in all things RevSoft
