I played around with being able to put HEADERS above the columns in a CHOOSE command. I think every programmer has wanted that since the "beginning of time"! I started out with RBTI's example code that runs against ConComp and it works great to display 2 columns of data. What I tried to do was add a third column to their example (the sys_table_type in the command below). It took quite a while, but my conclusions are: 1. You must have Vertical Lines ON. I am unable to get it to work without having vertical lines on. 2. I then fiddled with the Vertical Line Breaks line until the headers lined up perfect with the vertical lines. No rhyme or reason, I just plugged in random numbers til it worked. 3. Then I played with the Text Breaks line until the data all lined up perfectly. Has anyone used this? Am I correct in that you must have Vertical Lines ON? And I'm guessing there's no shortcut to guessing on the 2 list of numbers since pixels would depend on your font size, etc. I'll attach a picture of my choose command with the 3rd column added. Code below.
CHOOSE vTableViewName FROM #VALUES FOR + ((LJS(SYS_TABLE_NAME,35))&LJS(SYS_COMMENT,75) & ljs(sys_table_type,10)),SYS_TABLE_NAME FROM SYS_TABLES + WHERE SYS_TABLE_TYPE <> 'SYSTEM TABLE' ORDER BY SYS_TABLE_NAME ASC + CHKBOX 1 TITLE 'Select Table/View' + CAPTION 'Tables' LINES 26 FORMATTED + OPTION TITLE_BACK_COLOR WHITE + |TITLE_FONT_NAME Segoe UI + |TITLE_FONT_SIZE 16 + |TITLE_FONT_COLOR BLACK + |TITLE_BOLD ON + |LIST_BACK_COLOR WHITE + |LIST_FONT_NAME Tahoma + |LIST_FONT_SIZE 9 + |LIST_FONT_COLOR NAVY + |WINDOW_BACK_COLOR WHITE + |BUTTON_OK_CAPTION &Continue + |BUTTON_CANCEL_CAPTION C&ancel + |BUTTONS_SHOW_GLYPH ON + |LINE_COLOR black + |ZEBRA_STRIPES ON + |ZEBRA_ODD_COLOR 3DLIGHT + |ZEBRA_EVEN_COLOR WINDOW + |HORIZONTAL_LINES ON + |VERTICAL_LINES ON + |VERTICAL_LINE_BREAKS 150,450 + |TEXT_BREAKS 36,112 + |HEADERS Table Name,Description,Type Karen -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/660651785.1231586.1614092812858%40mail.yahoo.com.
