Thank you Razzak, this is a much appreciated time saver ! David Fitts State of Maine Risk Management Division
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Tuesday, June 14, 2016 10:02 AM To: [email protected] Subject: Re: [RBASE-L] - R prompt editing At 09:04 AM 6/14/2016, Fitts, David A. wrote: >Greetings everyone, > >When I use a command like: > >EDIT BUILDINGCOST FROM COSTTABLE WHERE BUILDINGNUMBER = '47' > >And the BUILDINGCOST values in dollars is over one million, the column >only shows the last 8 significant digits and look like >this 000,000.00 > >I can click on the column width to expand the column but does anyone >know if there is a change to the command or an Rbase settings that I >can use to show more than 8 digits of currency when editing or browsing >currency values? David, Use the recently implemented OPTION of using "COLUMN_WIDTH[nn] nn" to accomplish your goal. Using the latest build R:BASE X/R:BASE X Enterprise (Version 10) Build 10.0.1.20526 or higher, you can use the COLUMN_WIDTH parameter for the EDIT or BROWSE commands to specify the column width for a column, where X is the zero-based column index and Y is the width in pixels. The following example opens the Data Editor for active customer for the Customer table, with column alias names, a custom caption, and specified column widths for three that contain shorter data lengths. EDIT + CustID AS `Customer ID`, + Company AS `Company Entity`, + CustAddress AS `Home Office Address`, + CustCity AS `Home Office City`, + CustState AS `Home Office State`, + CustZip AS `Home Office Zip Code`, + CustPhone AS `Primary Phone Number`, + CustFax AS `Fax Number`, + LastUpdateDate AS `Last Date Modified`, + LastOrderDate AS `Last Order Date`, + CustURL AS `Company Home Page`, + CustEMail AS `Primary Email Address`, + CustStatus AS `Active Status`, + PaymentTerm AS `Payment Terms`, + CreditLimit AS `Imposed Credit Limit` + FROM Customer + WHERE CustStatus = 'A' + ORDER BY Company ASC + OPTION CAPTION 'Active Customer Information'+ |WINDOW_STATE NORMAL + |COLUMN_WIDTH[4] 50 + |COLUMN_WIDTH[5] 50 + |COLUMN_WIDTH[12] 50 That's all there is to it! Very Best R:egards, Razzak. -- 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]. For more options, visit https://groups.google.com/d/optout. -- 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]. For more options, visit https://groups.google.com/d/optout.
