Thanks Sami Thats a BIG duh and we'll start my tab for Project Bundleup for the october 21 - 24 conference
David David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: "Sami Aaron" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Monday, June 27, 2005 12:28 PM Subject: [RBG7-L] - Re: EDIT COLX=10 FROM table WHE ... - Does NotSeemToWork > David - > > For your #2 below - once you get the browser screen laid out the way you > want it, before you close the browser window, click on the menus - Layout / > Save Layout. > > Sami > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > Sami Aaron > Software Management Specialists > 913-915-1971 > [EMAIL PROTECTED] > > ________________________________ > > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of David M. > Blocker > Sent: Monday, June 27, 2005 11:22 AM > To: RBG7-L Mailing List > Subject: [RBG7-L] - Re: EDIT COLX=10 FROM table WHE ... - Does NotSeemToWork > > > Dave > > Let's take your points one at a time. > > 1. You are correct - I see the example you note in the EDIT help screen. I > suggest you contact RBTI via the web address posted by Razzak today for all > enhancement requests / bug reports. You can report this as: EITHER the > help screen is not up to date and should be corrected, because clearly the > EDIT colname=nnn feature no longer works in 7.x, OR the command should be > changed to work as advertised in the help sample. Since the =nn option does > NOT show in the syntax box, I suspect that the example is an error. > > 2. You SHOULD be able to achieve the effect you desire another way: using > SET LAYOUT ON. But I'm calling Razzak in on this one because it's not > working as I expect: > > Try this in CONCOMP > > 1. At the R> prompt, type SET LAYOUT ON > 2. Open the database explorer > 3. Click on Tables, double click on CONTACT to open the table. > 4. Using your mouse, adjust the column widths so they fill the screen > and make > the ContInfo - a note field - as wide as you can. > 5. Make a few other layout changes, such as a colulmn's background > color or > font. > 6. CLose the browse screen. > 7. Double click on CONTACT again: it SHOULD display as you left it, > with the > layout you set for this table, but it does not. > > Razzak, do I have the steps correct? Or am I misunderstanding how to use > SET LAYOUT? > > 3. Re SELECT. R:Base will normally display the maximum number of columns > it can, up to the current SET WIDTH value. > > At the R> prompt, type: SHOW WIDTH - it is probably set at the default, > 79 > > 4. Type: > > SELECT * FROM Contact > > All 6 columns in the table show on the screen, with the NOTE field > ContInfo wrapping at 15 characters, and ContPhoto showing just [BMP] if > there is an image. > > 5. Now try this: > > SELECT CustID=6, ContFName=10, ContLName=15, ContPhone=12, ContInfo=23, > ContPhoto from Contact > > ContInfo is wider, but you don't get ContPhoto because the total of > the widths > is > 79: (6 + 10 + 15 + 12 + 23) = 76 PLUS 1 blank before each colum > = 5 = > 81. > > 6. Type: SET WIDTH 90 > > 7. Repeat the above command: you DO get all 6 columns with the info column > showing wider. > > If you DO NOT get the effects I describe, then you need to change your font > for the R> prompt screen: > > Settings / R Prompt / Console Font: I use ASCII > > I hope this helps. > > Razzak, can you help us on SET LAYOUT? > > > David Blocker > [EMAIL PROTECTED] > 781-784-1919 > Fax: 781-784-1860 > Cell: 339-206-0261 > ----- Original Message ----- > From: dgallup <mailto:[EMAIL PROTECTED]> > To: RBG7-L Mailing List <mailto:[email protected]> > Sent: Monday, June 27, 2005 10:01 AM > Subject: [RBG7-L] - Re: EDIT COLX=10 FROM table WHE ... - Does NotSeemToWork > > Hello David, > Thanks for your input. It appears that I now have another problem. First I > tried the Concomp sample database and no matter what I did I could not get > any field to change when using > Edit colx=y from tablez where ... . I note that this form appears in the > sample help file Help|Table of Contents|Command Index|E under Examples, 2nd > from last example. From this example it seems that the field limitation to x > characters should work. For me it does not. I also tried using the select > command [which I seldom use] and found that it doesn't even produce a > table-like structure but displays the table columns in a list and looks like > the format you see when you use the command, List Col, that is it shows the > first three columns but no others in the table. It also does not truncate my > note field at all no matter what I try. > I have run Autochk with no errors returned and my other commands and > programs appear to function properly. I am using the build 7.1.81.30621 > > Dave. . > > David M. Blocker wrote: > > > Dave > > My experience IS different from yours on all counts. > > First of all, using the latest build downloaded just now, build > 7.1.81.30626, these two commands (TASK is a NOTE data type field): > > edit empid,workdate,task=20,hour from hour > edit empid,workdate,task=40,hour from hour > > yield the same results - the task column displays about 16 > characters, but > of course remember, this is WINDOWS - so unless you're using a fixed > space > font such as courier, the number of "characters" has no meaning. > That > said, i tried changing the default font (Settings / Data Browser / > Set > Default Font) to Courier New 8, and it did not change the behavior > of the > screen - just the number of characters displayed in both cases. > > Second of all, clicking on the Question mark for help, selecting > Command > Index, and checking both EDIT and BROWSE, I do NOT see the =width as > an > option any more - it IS there for SELECT where it works as > advertised. > Where are you finding this in the syntax in 7.1? > > David Blocker > [EMAIL PROTECTED] > 781-784-1919 > Fax: 781-784-1860 > Cell: 339-206-0261 > ----- Original Message ----- > From: "dgallup" <[EMAIL PROTECTED]> <mailto:[EMAIL PROTECTED]> > > To: "RBG7-L Mailing List" <[email protected]> > <mailto:[email protected]> > Sent: Sunday, June 26, 2005 8:44 PM > Subject: [RBG7-L] - Re: EDIT COLX=10 FROM table WHE ... - Does > NotSeem To > Work > > > > > Hello All, > > I employ a large table of book data containing a number of > columns. When > I attempt to call up a note col labeled Cand and limit its > display to 10 > characters, for example, using the > following command, Edit Col A Col B Cand=10 From (Table) > Where ColN GT > 30000, column CAND comes up fine, except it consumes the the > whole > screen. Have I missed something in all the updates > or what? I note that this method of display is still listed > in the > command help definitions under the samples and I know it > used to work. > Any help would be appreciated. I am using Update 81, RB 7.1. > > Dave Gallup, Ventura. > > > > > > > > > > > > > >
