July 11, 2007, 08:31 AM
Jason K.Drill down simple passing issue.
I'm recieving the following error when attempting to drill into a detailed report fex from a more summarized fex, they are built off seperate master files.
Here's my drilldown in the summary fex.
TYPE=DATA,
BACKCOLOR=( RGB(198 215 255) RGB(224 224 224) ),
TARGET='_blank',
FOCEXEC=matrixxg/app/wcqrgj18.fex(CUST_NUMBER=N5 REP_GRP_CHRONO='BYMONTH' REP_GRP_LOCALE='IGGY' REP_GRP_ATTRIB='CUSTPL'),
$
0 ERROR AT OR NEAR LINE 304 IN PROCEDURE wcqrgj18FOCEXEC *
(FOC280) COMPARISON BETWEEN COMPUTATIONAL AND ALPHA VALUES IS NOT ALLOWED
Line 304 is this...
WHERE CUSTOMER_NUMBER EQ 40050;
The calling fex is passing a field called "CUSTOMER_NUMBER" which is an A8 in the master file.
The recieving fex is showing customer number as A8.
Should it be enclosing the value in single ticks? I'm still very new to webfocus, so these problems are usually very simple fixes.
July 11, 2007, 08:47 AM
PrarieShould it be enclosing the value in single ticks?
Yes
| In Focus since 1993. WebFOCUS 7.7.03 Win 2003 |
July 11, 2007, 09:06 AM
<JG>Prarie,
You should be ashamed of your self.
NO it should not be enclosed in quotes because if you do that, it passes the absolute value
to the WHERE test, i.e. ‘N5’
Are you sure that N5 is the correct column designator?
Try using the actual column name instead.
July 11, 2007, 09:13 AM
PrarieNot awake...head hung low....
| In Focus since 1993. WebFOCUS 7.7.03 Win 2003 |
July 11, 2007, 09:50 AM
Jason K.FOCEXEC=matrixxg/app/wcqrgj18.fex(CUST_NUMBER=CUSTOMER_NUMBER REP_GRP_CHRONO='BYMONTH' REP_GRP_LOCALE='IGGY' REP_GRP_ATTRIB='CUSTPL'),
yields
WHERE CUSTOMER_NUMBER EQ 55000;
and, of course, the same error.
Doh!
Prod: Single Windows 2008 Server running Webfocus 7.7.03 Reporting server Web server IIS6/Tomcat, AS400 DB2 database.
July 11, 2007, 09:59 AM
<JG>Jason,
Code the WHERE as
WHERE CUSTOMER_NUMBER EQ '&CUSTOMER_NUMBER';
July 11, 2007, 10:29 AM
Jason K.it's always something simple.
thanks!
Prod: Single Windows 2008 Server running Webfocus 7.7.03 Reporting server Web server IIS6/Tomcat, AS400 DB2 database.
July 11, 2007, 10:55 AM
PrarieI think that is what I was trying to say this morning ....but was sleeping.
| In Focus since 1993. WebFOCUS 7.7.03 Win 2003 |
July 11, 2007, 11:12 AM
<JG>Sending and receiving. A real pain.
Basic rule, do not quote when sending unless it’s an absolute value.
Basic rule, Always quote when Receiving if it’s an ALPHA.