Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED]Passing a scalar value
Go
New
Search
Notify
Tools
Reply
  
[CLOSED]Passing a scalar value
 Login/Join
 
Silver Member
posted
I am new to WebFOCUS and not sure how it can use a self-contained subquery to pass a single value. Below is my sample code. Any help would be appreciated.


DEFINE FILE TableOne
CRDATE/YYMD = HDATE(CalendarDate, 'YYMD');
END

TABLE FILE TableOne
BY CalendarWeek
WHERE CalendarDay EQ &YYMD
ON TABLE HOLD AS CRWEEK

TABLE FILE TableTwo
SUM Price
BY Category
WHERE CalendarWeek EQ CRWEEK.CalendarWeek

This message has been edited. Last edited by: <Emily McAllister>,


WebFOCUS 8
Windows, All Outputs
 
Posts: 47 | Registered: February 02, 2016Reply With QuoteReport This Post
Virtuoso
posted Hide Post
WHERE CalendarWeek IN FILE CRWEEK;


WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010
: Member of User Group Benelux :
 
Posts: 1644 | Location: Enschede, Netherlands | Registered: August 12, 2010Reply With QuoteReport This Post
Master
posted Hide Post
Wep probably has guessed it right, but I find your code confusing. Your DEFINE creates a new filed called CRDATE that you don't explicitly reference in your table, so I'm wondering why you included the DEFINE in your example.

In your first TABLE you don't have a VERB or OBJECTS so it's tough to figure out what the intention is - what you will get are some values that have CalendarDay equal to today.

The second TABLE references CalendarWeek. Is this a database field?

Finally, since the first TABLE will just give you back today's date, why not just plug in &YYMD in the second table?


WebFOCUS 7.7.05 Windows, Linux, DB2, IBM Lotus Notes, Firebird, Lotus Symphony/OpenOffice. Outputs PDF, Excel 2007 (for OpenOffice integration), WP
 
Posts: 674 | Location: Guelph, Ontario, Canada ... In Focus since 1985 | Registered: September 28, 2010Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED]Passing a scalar value

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.