EXCELLENT point both of you. I do try to stop using rather old technology (like scrolling regions). I actually had another RBase programmer ask me if I had ever used Headers in Choose because he was trying to get it to work and couldn't so I told him I'd mess around with it a bit and get back to him
Karen -----Original Message----- From: [email protected] <[email protected]> To: RBASE-L <[email protected]> Sent: Tue, Feb 23, 2021 11:43 am Subject: Re: [RBASE-L] - Choose command with headers I'm with jan... been my pick for some years. On Tuesday, February 23, 2021 at 11:36:43 AM UTC-5 janj wrote: Karen, I guess I would have just done a quick form using a VariableListView. Jan From: "'Karen Tellef' via RBASE-L" <[email protected]> To: "[email protected]" <[email protected]> Date: Tue, 23 Feb 2021 15:06:52 +0000 (UTC) Subject: [RBASE-L] - Choose command with headers 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. -- 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/6a2e1631-944c-4a2f-8446-74d2950f18f9n%40googlegroups.com. -- 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/1680405237.1324863.1614106434983%40mail.yahoo.com.
