I have just been acquainted with the following:

  
SET HOLDATTR=ON 
TABLE FILE CAR
PRINT COUNTRY AS ('A', 'B', 'C')
END

will show A as title.

TABLE FILE CAR
PRINT COUNTRY AS ('A', 'B', 'C')
ON TABLE HOLD
END
!type hold.mas
will show B as field name and C as title.

Interesting.

This message has been edited. Last edited by: <Kathryn Henning>,

Indeed...

Took me a long time to find this:

COMPUTE FIELD/D12 TITLE 'Turnover' = BRT_TO;

Also great to create new titles for fields. Works in defines as well.

I even use it to 'rename' titles.

DEFINE FILE <our_bv>
    ITEM_NEW/A10 TITLE 'New Item' = ITEM;
END

thanks for the info...

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

Yes, it seems to respect the case of the text.

Brilliant.



I wonder if this is in the Keysheet ?

Interesting for the DEFINE but the COMPUTE example gives the same result as:

COMPUTE ITEM_NEW/D12=ITEM; AS 'New Item'

, no ?

WAZ,
It is in the DEFINE Fields section chapter 4 of the WebFOCUS Keysheet - it became available as of 7.7.01

George, consider this:

SET HOLDATTR=ON 
TABLE FILE CAR
PRINT COUNTRY
COMPUTE ITEM_1/D12 =SALES;  AS 'New Item 1'
COMPUTE ITEM_2/D12 TITLE 'New Item 2' =SALES;  AS 'New Item 2'
COMPUTE ITEM_3/D12 =SALES;  AS ('New Item 3', 'Item_3', 'New Item 3')
ON TABLE HOLD
END
-RUN
! type hold.mas

quote:

AS ('A', 'B', 'C')

Danny, how did you find out about this.

Where is this keysheet I keep reading about?

DBA, its the bible
http://www.aviter.com/keysheet/
we all have one , at least one, dog-earred and guarded.

Thank you Susannah!

Hello DBADiaz,

If you are interested and would like, drop me an email at vivian@aviter.com and I will forward to you samples from the Keysheet and Dates books/PDFs. If you are attending Summit, please drop by my table and you can look at them "in person".

I think you will be positively impressed.

there should be a 'book signing party', just like on Castle.

Well, I was thinking of having my son-in-law Christian Lagadec who is currently the castle spy on Grimm grace my desk at Summit.

Is that close to Castle??? One day we will have a book signing party --- when Summit comes to the west coast and John Price, author, does not have to travel so far from his chair!

quote:

!type hold.mas

Hi Danny,

Thanks for the great share.

I've never seen/used '!type'.

Is '!' a way to escape to the operating system?

Is 'type' in this case, the DOS command 'type' to print out the contents of a file?

How does the command know what folder contains the .mas?

Thanks,
Dave

quote:

Is '!' a way to escape to the operating system?

Yes it it.