Re: Another JDBC (and by extension, JDBCR4) meta-data retrieval question

On Fri, Apr 5, 2013 at 3:19 PM, CRPence <CRPbottle@xxxxxxxxx> wrote:

On 05 Apr 2013 11:44, John Yeung wrote:

I see that DBU also tries to, in its way; which happens to make
manual entry of many valid values impossible.

I know almost nothing of DBU, but there should be no reason that
particular utility would have to or even should prevent entering any
valid floating point value [double or single, according to the Floating
Point Precision] irrespective of the presentation of the current
value... just like a display file.

The version of DBU we have installed here has fixed-size input fields.
For a float defined with 8 digits of total precision, the field is 10
characters (one for decimal point and one for sign). The way in which
it "honors" the scale preference is to automatically shift your input
to "line up" the decimal point "where you wanted it".

So, for a DDS-defined (8 5) single-precision float, if I try to enter

12345.67

it shifts things over to ensure 5 places after the decimal point,
which ought to be

12345.67000

but due to the size of the input field, what I wind up with is

345.67000

In other words, it looks like DBU is really giving me a DECIMAL (8 5)
field, which just happens to be stored as a float in the file. Truly
disappointing.

John