RList failure due to apparent Catalog problem. (AREV Specific)
At 21 MAR 2002 01:31:35AM Lee M Harwell wrote:
RE: Arev Version 2.11
I have a small database (6 fields) which appears to perform Okay in the data entry screen for all fields. However, when I run a RList command I have a problem. All field data appears okay EXCEPT for one. If I include that field, called "INSURER" the report fails and I get the following Arev Message:
"List 2 cannot be executed because it has not been cataloged."If I leave INSURER out of my report all other data fields show up okay.
I do not know what "List 2" is referring to, as I have no field with that name.
The field "INSURER" is an associated multivalue field. This data field works okay in the data entry screen, but fails to work in any Rlist commands.
I need to run an exploding sort on this field so that I can migrate ALL of the data in this field out of AREV. I cannot accomplish this until the AREV system will recognize this field. The dictionary definition appears okay.
Any idea how I can remedy this situation?
At 21 MAR 2002 01:03PM Don Miller - C3 Inc. wrote:
One way to do this is to generate the R/LIST code:
LIST WHATEVERFILE BY WHATEVERFIELD WHATEVERFIELDS… (SX)
This will create a DOS record called RLIST.
Copy this to a convenient file:
COPY DOS RLIST TO:(SOMEFILE TESTPROG
Then BASIC SOMEFILE TESTPROG
.
Next do your select / sort
SELECT WHATEVERFILE BY ..
RUN SOMEFILE TESTPROG
You should get the line in the program where the error is occuring.
If it is in a braces call {FIELD} then the dictionary element contains an error. Otherwise, you might be missing a VOC element that gives the totals, etc.
HTH
Don Miller
C3 Inc.