On Feb 27, 2007, at 5:17 PM, Chuck Hill wrote:
> I don't have any strong feelings about it. Today was just the
> first time I ever heard of a negative scale.
As of Oracle 9i, the scale for the numeric type s can range from -84
to 127.
sacha
> On Feb 27, 2007, at 4:32 PM, Q wrote:
>
>> Good point, but perhaps a negative scale should generate a warning
>> in Entity Modeler rather than preventing it entirely.
>>
>> On 28/02/2007, at 10:07 AM, Chuck Hill wrote:
>>
>>> Maybe for EOModeler, but the SQL92 standard says,
>>>
>>>> An exact numeric value has a precision and a scale. The precision
>>>> is a positive integer that determines the number of
>>>> significant
>>>> digits in a particular radix (binary or decimal). The
>>>> scale is a
>>>> non-negative integer. A scale of 0 indicates that the
>>>> number is an
>>>> integer. For a scale of S, the exact numeric value is
>>>> the integer
>>>> value of the significant digits multiplied by 10-S.
>>
>>
>> --
>> Seeya...Q
>>
>> Quinton Dolan - qdola..mail.com
>> Gold Coast, QLD, Australia
>> Ph: +61 419 729 806
>>
>>
>>
>
> --
>
> Practical WebObjects - for developers who want to increase their
> overall knowledge of WebObjects or who are trying to solve specific
> problems.
> http://www.global-village.net/products/practical_webobjects
>
>
>
>
>
>
-- Sacha Michel Mallais Senior Developer / President Global Village Consulting Inc. http://www.global-village.net/ PGP Key ID: 7D757B65 AIM: smallais "The bird of paradise alights only upon the hand that does not grasp." -- John Berry
This archive was generated by hypermail 2.0.0 : Tue Feb 27 2007 - 20:28:51 EST