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 have any questions or need access: Contact firstname.lastname@example.org
No I am not creating a Hold File at this point, and that code only worked for so long and then all of a sudden the titles were back. This is my code: -**My Output fields say MAX.OUT_BENG, etc...
SQL SQLMSS SET DEFAULT_CONNECTION PIW_DEV SQL SQLMSS SELECT QUEST_ID, ANSWER_ID, ANSWER FROM T_ANSWER WHERE QUEST IN (329,872,330,331,332,820,333,334,337); TABLE FILE SQLOUT PRINT * ON TABLE HOLD AS HOLDREM END
DEFINE FILE HOLDREM OUT_BENG/A2000 = IF QUEST EQ 329 THEN ANSWER ELSE ' '; OUT_BENN/A2000 = IF QUEST EQ 872 THEN ANSWER ELSE ' '; OUT_KITC/A2000 = IF QUEST EQ 330 THEN ANSWER ELSE ' '; OUT_KITN/A2000 = IF QUEST EQ 331 THEN ANSWER ELSE ' '; OUT_KITT/A2000 = IF QUEST EQ 332 THEN ANSWER ELSE ' '; OUT_FORM/A2000 = IF QUEST EQ 820 THEN ANSWER ELSE ' '; OUT_TRIG/A2000 = IF QUEST EQ 333 THEN ANSWER ELSE ' '; OUT_MAIL/A2000 = IF QUEST EQ 334 THEN ANSWER ELSE ' '; OUT_COMM/A2000 = IF QUEST EQ 337 THEN ANSWER ELSE ' '; END
TABLE FILE HOLDREM SUM MAX.OUT_BENG AS 'Benefit,Group' MAX.OUT_BENN AS 'Benefit,Group,Notes' MAX.OUT_KITC AS 'Kit,Code' MAX.OUT_KITN AS 'Kit,Name' MAX.OUT_KITT AS 'Kit,Type' MAX.OUT_FORM AS 'Include,Form' MAX.OUT_TRIG AS 'Trigger,Timing' MAX.OUT_MAIL AS 'Mail,Timing' MAX.OUT_COMM AS 'Comments' BY ANSWER_ID NOPRINT END
Would it have anything to do with the commas in my titles? I need them to wrap because they are too long.
Well it looked like it solved it, but then the problem seemed to reappear... so in actuality the problem wasn't resolved. Does that makes sense? Because originally the column titles used to come out right only some of the time, and wrong the other times. I don't know why this would happen either.
yep, agreed, strange indeed, Mickey, yet sometimes it works (even tho it should have no effect ) on a report when that report comes out of a long dense fex. I always try it first when i have a screwup...and the su goes away. absolute mystery.
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003
Not to twist the knife, Susannah, but I'd think, given recent events, that you'd be just a tad wary of accruing a collection of programs that use code that isn't supposed to work. And, slfmr, you might wary of that yourself, lest IBI decides in some future release to plug the hole that lets this work, leaving you with one or a billion programs that no longer work.
Posts: 135 | Location: Portland, OR | Registered: March 23, 2005