I'm with jan... been my pick for some years.[image: lvwChoose.jpg] 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 > > <https://groups.google.com/d/msgid/rbase-l/660651785.1231586.1614092812858%40mail.yahoo.com?utm_medium=email&utm_source=footer> > . > > -- 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.
