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. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] problem with dropdown not loading correctly

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] problem with dropdown not loading correctly
 Login/Join
 
Member
posted
We have a chained dropbox that is supposed to load a selected item and all items following in alphabetic order. The problem is that the loaded box only contains the item selected from the chained drop down and not the ones following. I put the same chained focexec in a report frame and it loads correctly.

The code is below.

-DEFAULT &GEOLOC_PARM = 'WWYP';
-*-DEFAULT &GEOLOC_PARM '_FOC_NULL';

-*-DEFAULT &STRT_WRK = '_FOC_NULL';

-? &
DEFINE FILE LKUP_WORKCENTERS
SORT_FIELD/A10 = GEOLOC_CODE | WORKCENTER;
SHOP_LIST_END/A170 = WORKCENTER || ' -' | ' ' | SHOP_MNEMONIC | ' ' | ' - ' | ' (' | SHOP_NAME | ')';
END


TABLE FILE LKUP_WORKCENTERS
ON TABLE SET PAGE-NUM OFF
ON TABLE SET PRINT ONLINE
SUM SHOP_LIST_END
BY SORT_FIELD
BY WORKCENTER
WHERE GEOLOC_CODE EQ '&GEOLOC_PARM';
-*WHERE WORKCENTER GE '&STRT_WRK' ;
WHERE SHOP_MNEMONIC NE 'HOLD';
WHERE WORKCENTER NE 'HOLD ';
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT XML
-*ON TABLE HOLD AS HOLD_END_WRK
END
-RUN

Any suggestions will be appreciated.

Bob

This message has been edited. Last edited by: FP Mod Chuck,


8.201, Windows/Unix
 
Posts: 5 | Location: Oklahoma City | Registered: April 17, 2020Report This Post
Member
posted Hide Post
I got the first one resolved now the only problem is with the double list box. It contains data resulting in a GE and a LE Where statement. I'm getting a message telling me that there is an issue chaining the combobox to the customselect box. I'm not able to get it resolved using the settings tab after right clicking on the chain arrow.


8.201, Windows/Unix
 
Posts: 5 | Location: Oklahoma City | Registered: April 17, 2020Report This Post
Member
posted Hide Post
DEFINE FILE V_WRKCTR_TRNG_COURSES
NEW_GEOLOC/A5 = IF COMMAND EQ 'AMC' AND GEOLOC_CODE EQ 'NKAK' THEN 'NKAKA'
ELSE IF COMMAND EQ 'AETC' AND GEOLOC_CODE EQ 'NKAK' THEN 'NKAKB'
ELSE GEOLOC_CODE;
COURSE/A10 = COURSE_PREFIX | COURSE_CODE;
COURSE_SORT_FIELD/A10 = COURSE;
COURSE_LINE/A128 = COURSE || ' - ' |NOMENCLATURE;
END

TABLE FILE V_WRKCTR_TRNG_COURSES
ON TABLE SET PAGE-NUM OFF
ON TABLE SET PRINT ONLINE
SUM COURSE_LINE AS ''
BY COURSE_SORT_FIELD NOPRINT
BY COURSE
WHERE NEW_GEOLOC EQ '&GEOLOC_PARM'
-IF (&STRT_WRK EQ '$*') AND (&END_WRK EQ '$*') THEN GOTO SKIPWRK;
WHERE WORKCENTER GE '&STRT_WRK' ;
WHERE WORKCENTER LE '&END_WRK' ;
-SKIPWRK;
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT XML
END
-RUN


8.201, Windows/Unix
 
Posts: 5 | Location: Oklahoma City | Registered: April 17, 2020Report This Post
Virtuoso
posted Hide Post
Hi Bob

What is the webfocus error message number you are getting.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 2128 | Location: Customer Support | Registered: April 12, 2005Report This Post
Member
posted Hide Post
I'm getting a message telling me that there is an issue chaining the combobox to the customselect box.


8.201, Windows/Unix
 
Posts: 5 | Location: Oklahoma City | Registered: April 17, 2020Report This Post
Virtuoso
posted Hide Post
No error number?


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 2128 | Location: Customer Support | Registered: April 12, 2005Report This Post
Member
posted Hide Post
There is just a yellow caution triangle and the message that there is a problem. I had gone thru all the options in the resolves area in the chain settings and still get the message. The only thing I can think of is that the value of the chained variable contains an alpha char, A0000, and we are using a GE and LE in the where. I can get it to work using integers but not alpha chars.


8.201, Windows/Unix
 
Posts: 5 | Location: Oklahoma City | Registered: April 17, 2020Report This Post
Virtuoso
posted Hide Post
Bob

If this is still an issue please open a case with techsupport if you haven't already.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 2128 | Location: Customer Support | Registered: April 12, 2005Report 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     [CLOSED] problem with dropdown not loading correctly

Copyright © 1996-2020 Information Builders