 |
|||||
|
As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Join the TIBCO Community
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community. | |||||
Read-Only TopicGo | Search | Notify | Tools |
| [SHARING] Customized HOLD file | Login/Join |
| Virtuoso |
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>, Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF | ||
|
| Master |
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, _____________________ WF: 8.0.0.9 > going 8.2.0.5 | |||
|
| Expert |
Yes, it seems to respect the case of the text. Brilliant.  I wonder if this is in the Keysheet ? Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Master |
Interesting for the DEFINE but the COMPUTE example gives the same result as: COMPUTE ITEM_NEW/D12=ITEM; AS 'New Item', no ? WebFOCUS 7.7.05 Windows, Linux, DB2, IBM Lotus Notes, Firebird, Lotus Symphony/OpenOffice. Outputs PDF, Excel 2007 (for OpenOffice integration), WP | |||
|
| Silver Member |
WAZ, It is in the DEFINE Fields section chapter 4 of the WebFOCUS Keysheet - it became available as of 7.7.01  WebFOCUS 8.0.2, FOCUS since 1977 - John@Aviter.com PDF , Excel, FOCUS, Author of the Keysheets and Dates book. www.Aviter.com | |||
|
| Expert |
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
Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Expert |
Danny, how did you find out about this. Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Member |
Where is this keysheet I keep reading about? Release: DevStudio 7703 OS: Win7 Outputs: HTML, PDF, EXCEL | |||
|
| Expert |
DBA, its the bible http://www.aviter.com/keysheet/ we all have one , at least one, dog-earred and guarded.
| |||||
|
| Platinum Member |
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. Vivian Perlmutter Aviter, Inc. WebFOCUS Keysheet Rel. 8.0.2 (Almost) 1001 Ways to Work with Dates thru Rel. 8.0.2 Focus since 1982 WebFOCUS since the beginning Vivian@aviter.com | |||
|
| Expert |
there should be a 'book signing party', just like on Castle.
| |||||
|
| Platinum Member |
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! Vivian Perlmutter Aviter, Inc. WebFOCUS Keysheet Rel. 8.0.2 (Almost) 1001 Ways to Work with Dates thru Rel. 8.0.2 Focus since 1982 WebFOCUS since the beginning Vivian@aviter.com | |||
|
| Master |
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
| ||||
|
| Expert |
Yes it it. Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |