On Feb 27, 2007, at 5:28 PM, Sacha Michel Mallais wrote:
> 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.
Oh, and that makes me feel so much better! whOracle, leading the
standards way one deviation at a time.
Chuck
>
>
>> 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
>
>
>
--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
This archive was generated by hypermail 2.0.0 : Tue Feb 27 2007 - 20:36:04 EST