FYI: Hope it helps somebody.
Do a lot of prototyping from the R>Prompt where it's easy (for me) to
forget what tools are available.
Bugged that can never fit an entire (long) row on screen. Too much
horizontal scrolling and fooling around.
Find this in R:SYNTAX
BROWSE ... OPTION ROWVIEW
EDIT ... OPTION ROWVIEW
End of issue!
Bruce Chitiea
SafeSectors, Inc.
909.238.9012 Mobile
------ Original Message ------
Sent: 6/14/2016 7:01:47 AM
Subject: Re: [RBASE-L] - R prompt editing
From: "A. Razzak Memon" <[email protected]>
To: [email protected]
Cc:
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.
