Jump to content

Here is a model of the code I am developing: TABLE FILE GGOR...


David Briars

Recommended Posts

Here is a model of the code I am developing:

TABLE FILE GGORDER

SUM PRODUCT_ID

-*

COMPUTE NEW_PRODUCTID_P12/D12.2C MISSING ON = MISSING;

COMPUTE NEW_PRODUCTID_A12/A12 MISSING ON = MISSING;

BY STORE_CODE

BY PRODUCT_DESCRIPTION

IF STORE_CODE EQ 'R1250'

IF RECORDLIMIT EQ 1

ON TABLE SET NODATA 'NODATA'

ON TABLE HOLD AS JAVATEMP FORMAT HTMTABLE

ON TABLE SET PAGE-NUM OFF

ON TABLE SET STYLE *

INCLUDE=IBFS:/WFC/Repository/FACTS/code/stylesheets/jellybean_combo.sty, $

TYPE=DATA, COLUMN=PRODUCT_ID, JAVASCRIPT=showitem(PRODUCT_DESCRIPTION NEW_PRODUCTID_P12 NEW_PRODUCTID_A12),$

ENDSTYLE

END

-RUN

-HTMLFORM BEGIN

<html>

<head>

<script language="JavaScript">

// This function will display the values passed by the JAVASCRIPT StyleSheet within a message box.

function showitem(string1, string2, string3) {

alert('PRODUCT: ' + string1 + 'nNEW_PRODUCTID_P12: ' + string2 + 'nNEW_PRODUCTID_A12: ' + string3);

}

</script>

</head>

<body>

!IBI.FIL.JAVATEMP;

</body>

</html>

-HTMLFORM END

 

The missing data in my report respects the NODATA setting.

The missing data, passed back to the web page, with the JAVASCRIPT StyleSheet command seems to take on its own way of storing/displaying missing data, . for alphas, and -9998 for numerics.

 

Can anyone assist with tweaking the model, such that, the NODATA setting, passes into and through the StyleSheet/JAVASCRIPT construct

Link to comment
Share on other sites

What version of Internet Exploder are you stuck with using I tested it on IE11 and get one out of two:

 

That said, it lloks like it is something in the way WebFOCUS passes null values when building the JS. It looks like it is handled differently with text vs a number.

Inspecting the code you can see that in the way WebFOCUS builds the href on the anchor tag.

 

I would open a ticket.

Link to comment
Share on other sites

  • 4 weeks later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
  • Create New...