[Valentina] [OFF] Decimal field in mySQL

[Ruslan Zasukhin]

on 1/18/03 9:50 PM, Frank Schima at macsforever2002 at yahoo.com wrote:

> --- Ruslan Zasukhin <sunshine at public.kherson.ua> wrote:
>> Anybody have use Decimal field in mySQL ?
>> 
>> I wonder, because by sources, it looks like they do not have implemented
>> arithmetic for decimals ???
>> 
>> You should be able easy check this:
>> 
>> Make table with f1 and f2 decimal fields.
>> Make one records { 3.4  4.8 }
>> 
>> Now do 
>> 
>>     SELECT f1 + f2 FROM T
>> 
>> By sources I see that result will be 7.
>> 
>> Can anybody check this and confirm ?
> 
> Yes, this works in MySQL.

Frank,

What work?

It return 7 ?

But this is not correct, must be 8.6 as answer.


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://listserv.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------