Hi, I am working to open up an AREV table inside of OpenInsight.

I renamed the columns within AREV as follows:

  copy dict tablename col.name to:colname (D

When I run a "listdict tablename", I can see the renamed columns just fine. However, when I run the Inet_OI_XML() function inside of an OI column, I see the following error message:

"SYS1004: Error loading dictionary item "col.name".

Clearly, some trace of the original column name is hanging around.

Any ideas?

I tried detaching and re-attaching the table using the database manager and this did not help.

John,

It may be due to a calculated/symbolic column within the table. The code in the field may be pointing to col.name.

Sean

Hi Sean,

I think you might be right. Do you know of a way that I can turn a calculated column into a static column without emptying it of its contents?

Thanks for your help!

John David

Use table builder to look at the formula for the symbolic and change any column name with '.'

Hi John David,

Calculated columns don't have contents. They have a formula.

That formula, visible from the Table Builder tool, can reference other columns. For example a formula for a FULL_NAME column might look like

@ans={LAST.NAME} : ", " : {FIRST.NAME}

Sean is suggesting you need formulas containing '.' to '_', for example

@ans={LAST_NAME} : ", " : {FIRST_NAME}

If you are able to create a routine in arev to copy each row in the dictionary, this is the method I used years ago.

Test for a data or calculated row in the dictionary (FMC position 1 F or S

When you find a calculated row copy it to the new name and move the contents of the line at FMC position 8 (The formula) to FMC position 14 (The column description) and replace FMC position 8 (The formula) by removing the "." from any dictionary references in the formula.

View this thread on the Works forum...