Thanks Mike!!
David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: "MikeB" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Sunday, November 14, 2004 9:04 AM Subject: [RBG7-L] - RE: Fixed widths for columns in variable list box > > ----- Original Message ----- > From: "David M. Blocker" <[EMAIL PROTECTED]> > To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> > Sent: Saturday, November 13, 2004 3:56 PM > Subject: [RBG7-L] - RE: Fixed widths for columns in variable list box > > > > Mike > > > > I see that these work and are just what I want so I'll use them! This is > > great stuff! > > > > A few questions for you so I can understand what I'm doing and not just copy > > it slavishly, thought that certainly has its place! > > > > > > > > 1. What is CHAR(160)? What character is that? It appears to be a > > hard space? Whatever it is, it actually helped MY workaround! Instead of > > using > > > > ((LJS(InvNum,20))+ '.'),ImpDOIN,ExistDOIN > > > > I used: > > > > ((LJS(InvNum,20))+ CHAR(160)),ImpDOIN,ExistDOIN > > > > and the regular list box now lines up correctly! > > > > Yes a Hard Space.. > > > > > 2. Not all properties of the Variable User Defined Listboxes that you > > use are documented in the current version of R:Docs. Can you clarify what > > they do? > > > > 1. From Form Rolodex, On After Start EEP: > > > > 1. PROPERTY lbrolodex listitemsclear 'TRUE' - does this clear out any > > items in the box? > > Yes.. > > > 2. PROPERTY lbrolodex multiselect 'TRUE' - what does this do? > > It sets the Listbox to allow the selection of multiple items, but it should not > be used in a production app yet as there is no corresponding Property to > determine the indexes of the items that are highlighted in the multiple > selection. I used a cheat of a hidden listbox to add or remove items that are > selected, but the caveat is that it only works when items are added to the > selection One At A Time, so steer clear of it for now. > > > > 3. PROPERTY lbrolodex load_from_file 'Rolodex.lff' - this one is > > clear - it loads the list box from the file > > Yes > > > 2. Those on form MultiCol are documented. > > > > > > > > > > > > By the way, in running Rolodex from RUN STARTUP.RMD, in the latest beta > > build 78, if you select one of the addresses a smaller form comes up showing > > more details about that address. At that point you are hung and need a > > ctrl-alt-del to continue. No key or mouse strokes get you out of that > > popped up form. Any idea what this is about? > > > > If you notice the slightly off color horiz bar at the top and the verticle bar > at the right, that is a pushbutton that closes the form. It was just doing > something a little different for the demo, not something you would sneak into a > production app. > > > > > > Many thanks! > > > > > > > > David > > > > > > > > David Blocker > > [EMAIL PROTECTED] > > 781-784-1919 > > Fax: 781-784-1860 > > Cell: 339-206-0261 > > ----- Original Message ----- > > From: "MikeB" <[EMAIL PROTECTED]> > > To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> > > Sent: Saturday, November 13, 2004 9:26 AM > > Subject: [RBG7-L] - RE: Fixed widths for columns in variable list box > > > > > > > Also another method is on the form MultiColumn, look at the code behind > > load > > > multi column listbox. > > > > > > > > > ----- Original Message ----- > > > From: "David M. Blocker" <[EMAIL PROTECTED]> > > > To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> > > > Sent: Friday, November 12, 2004 1:54 PM > > > Subject: [RBG7-L] - RE: Fixed widths for columns in variable list box > > > > > > > > > > Buddy > > > > > > > > Nice try, but same result. Actually, since the column's values are > > TEXT - > > > > numbers and letters are possible, I had to change it to: > > > > > > > > (LJS(CTXT(FORMAT(invnum,'%%%%%%%%%%%%%%%%%%%%'),20)) > > > > > > > > but the result is the same - in the list box, R:Base just shrinks the > > size > > > > of the data displayed based on the data in the set. > > > > > > > > David Blocker > > > > [EMAIL PROTECTED] > > > > 781-784-1919 > > > > Fax: 781-784-1860 > > > > Cell: 339-206-0261 > > > > ----- Original Message ----- > > > > From: "Walker, Buddy" <[EMAIL PROTECTED]> > > > > To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> > > > > Sent: Friday, November 12, 2004 1:28 PM > > > > Subject: [RBG7-L] - RE: Fixed widths for columns in variable list box > > > > > > > > > > > > David > > > > Have you tried formating the number example > > > > > > > > (LJS(CTXT(FORMAT(invnum,'99999999999999999999')),20)) > > > > > > > > The 9s will suppress any 0s. If you want to show the preceding 0s then > > > > just change the 9s to 0s. > > > > > > > > > > > > Buddy > > > > > > > > -----Original Message----- > > > > From: David M. Blocker [mailto:[EMAIL PROTECTED] > > > > Sent: Friday, November 12, 2004 1:16 PM > > > > To: RBG7-L Mailing List > > > > Subject: [RBG7-L] - Fixed widths for columns in variable list box > > > > > > > > > > > > I've created a simple form with a variable list box, showing three > > columns: > > > > > > > > InvNum TEXT 15 > > > > ImpDOIN DATE > > > > ExistDOIN DATE > > > > > > > > The properties of the list box are: > > > > > > > > Source: InDupPik (view) > > > > Key column: InvNum > > > > Multiple columns checked > > > > Columns chosen: > > > > > > > > (LJS(InvNum,20)),ImpDOIN,ExistDOIN > > > > > > > > WHERE clause: > > > > WHERE ImportID = .fImportID ORDER BY InvNum > > > > > > > > I have checked off "Show lines" > > > > > > > > The problem is that the width of InvNum varies with the data being > > > > displayed. If the longest invoice number is 6 characters, R:Base seems > > to > > > > ignore the LJS and displays only the characters needed. This is all > > well, > > > > but I have column headings as Static text controls on the form above > > each > > > > column and it would be MUCH simpler to just locate these rather than go > > > > through a complex calculation to find the widest value being displayed > > and > > > > move the controls over so they stay above the columns. > > > > > > > > One work around I've found which I'm not crazy about is to change the > > > > expression to: > > > > > > > > ((LJS(InvNum,20))+ '.'),ImpDOIN,ExistDOIN > > > > > > > > This places a period after each value and forces R:Base to show a fixed > > > > width. But the period is very klugy. Is there a better solution? > > > > > > > > David Blocker > > > > [EMAIL PROTECTED] > > > > 781-784-1919 > > > > Fax: 781-784-1860 > > > > Cell: 339-206-0261 > > > > > > > > > >
