SET ASNAMES=ON
SET HOLDLIST=PRINTONLY
SET HOLDFORMAT=ALPHA
TABLE FILE CAR
SUM
SEATS
ACROSS COUNTRY
ON TABLE HOLD AS H001
END
?FF H001

TABLE FILE H001
PRINT
COMPUTE S1/D5 = SEAENGLAND;
COMPUTE S2/D5 = SEAW GERMANY;
END

The first TABLE produces a HOLD file with these columns:

SEAENGLAND, SEAFRANCE, SEAITALY, SEAJAPAN, SEAW GERMANY.

How does one reference the column with name "SEAW GERMANY" (the 2nd COMPUTE in this example throws an error)? I would rather not use "SEAW" or "E05".

Thanks,

This message has been edited. Last edited by: Francis Mariani,

You use quotes around the field.

Not sure if its single or double.

I think Developer Studio does this for you, a good place to test it.

The problem with using quotes:

COMPUTE S2/D5 = 'SEAW GERMANY' * 123;

This does not work.

Amazingly, I cannot manipulate The Dev Studio GUI to create a report based on a HOLD file! Am I an idiot?

If you create the hold file earlier in the fex in the DEV Studio GUI, you should see it in the list of tables the GUI throws up, in the next piece of its "necklace".

You may reference field names with a space as verb objects using single quotes. People use to do this to make for "pretty" column heading.

It also had the effect of driving the support people crazy (also know as me) , when the someone called about error caused by omitted single quotes. The syntax would looked perfect unless you looked at the master. Asking for the master file description often became a "teaching moment" because the caller had never heard of such a thing. They just copied from someone else, and "only made a little change".



TABLE FILE INSURE
SUM
'WRITTEN PREMIUM'
'EARNED PREMIUM'
BY POLICY
END


But in compute / define to the left of an equal sign "=" Focus assumes anything in single quotes is a literal.

My advice get ride of the "blank-it-blank" space.

Hi

Another option to use the internal columns numbering in the report itself

SET ASNAMES=ON
SET HOLDLIST=PRINTONLY
SET HOLDFORMAT=ALPHA
TABLE FILE CAR
SUM
SEATS
ACROSS COUNTRY
ON TABLE HOLD AS H001
END
-RUN



TABLE FILE H001
PRINT
'H001.H001.SEAW GERMANY' NOPRINT
COMPUTE AA/D5=C1 * 5;
COMPUTE DD/D5=SEAENGLAND;

ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = endeflt,
$
ENDSTYLE
END

This message has been edited. Last edited by: WF_IL,

Looks like you can only use the fields as a verb or sort field.

Defines or Computes just won't work.

Is this from the ACROSS HOLD only ?, if so, then prep the data prior to holding, converting all apaces to '_'.

I couldn't get a simple fex that reports off a HOLD file to work in the GUI - I have GUI-phobia and the GUI knows it.

Waz, as you suggested, I decided on ensuring there were no blanks in the values that are used in the ACROSS - so all is good.

Thanks,