[RBG7-L] - Re: EDIT COLX=10 FROM table WHE ... - Does NotSeemToWork

[David M. Blocker]

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 To: RBG7-L Mailing List 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]> To: "RBG7-L Mailing List" <rbg7-l@rbase.com> 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.