Focal Point Banner


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
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

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.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] (FOC36346) INCORRECT USE OF DATE-TIME FIELD OR CONSTANT

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] (FOC36346) INCORRECT USE OF DATE-TIME FIELD OR CONSTANT
 Login/Join
 
Noveta
Member
posted
(FOC36346) INCORRECT USE OF DATE-TIME FIELD OR CONSTANT
(FOC009) INCOMPLETE REQUEST STATEMENT
BYPASSING TO END OF COMMAND

I have a summary report and a detail report.
I am trying to pass a date field from the summary report to the detail report. Both columns are the same format and the detail report (I am using as a drill down)..

The parameters I am passing are userid, seqno and activity_date.

When I run the fex I will be using in the drill down independently..it recognizes the date and time and returns output correctly. But If i try to use the fex as a drill down it doesn't work. I get the error above.

But it looks like it is passing the right information but with quotes around it.

WHERE ROALOGD_ACTIVITY_DATE EQ 'DT(2005/03/14 8:36:33AM)'
WHERE ROALOGD_LOGM_SEQ_NO EQ '1'
WHERE ROALOGD_USER_ID EQ 'JJACQUET'


But it is putting the date in quotes.

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


7.6.2
 
Posts: 20 | Location: 7.6.2 | Registered: November 04, 2008Report This Post
Waz
Expert
posted Hide Post
Try taking the quotes from the DT command.

I assume Activity_Date is a Date Time field.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Noveta
Member
posted Hide Post
quote:
assume Activity_Date is a Date Time field.

Yes it is.
FIELDNAME=ROVLOGM_ACTIVITY_DATE, ALIAS=ROVLOGM_ACTIVITY_DATE, USAGE=HYYMDSA, ACTUAL=HYYMDSA, $

FIELDNAME=ROALOGD_ACTIVITY_DATE, ALIAS=ROALOGD_ACTIVITY_DATE, USAGE=HYYMDSA, ACTUAL=HYYMDSA,
DESCRIPTION='ACTIVITY DATE: The date that information for this row in the table was entered or last updated.', $


7.6.2
 
Posts: 20 | Location: 7.6.2 | Registered: November 04, 2008Report This Post
<JG>
posted
What we actually need to see is the drilldown code from the stylesheet and the actual Where clause from the drilldown focexec.

As Waz says the quotes are what is most likely causing the problem.
 
Report This Post
Noveta
Member
posted Hide Post
quote:
quotes from the DT command.

I thought I did that before. I took the quotes out and it worked.

Summary report

TABLE FILE SJC_ROVLOGMTST
PRINT
ROVLOGM_USER_ID
ROVLOGM_ACTIVITY_DATE
ROVLOGM_SEQ_NO
ROVLOGM_ID
FULLNAME
HEADING
""
FOOTING
""
WHERE ROVLOGM_ID EQ '&ROVLOGM_ID';

Drill down report

TABLE FILE ROALOGD
PRINT
ROALOGD_USER_ID
ROALOGD_ACTIVITY_DATE
ROALOGD_LOGM_SEQ_NO
ROALOGD_COLUMN_NAME
ROALOGD_TO
BY ROALOGD_ACTIVITY_DATE
-*WHERE ROALOGD_ACTIVITY_DATE EQ DT('3/14/2005 8:36:33')
-*WHERE ROALOGD_LOGM_SEQ_NO EQ 1
-*WHERE ROALOGD_USER_ID EQ 'JJACQUET'
WHERE ROALOGD_ACTIVITY_DATE EQ &DDATE
WHERE ROALOGD_LOGM_SEQ_NO EQ '&SEQNO'
WHERE ROALOGD_USER_ID EQ '&USERNAME'

Thanks..


7.6.2
 
Posts: 20 | Location: 7.6.2 | Registered: November 04, 2008Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] (FOC36346) INCORRECT USE OF DATE-TIME FIELD OR CONSTANT

Copyright © 1996-2020 Information Builders