[V4Rb] Aggregate field question

Ruslan Zasukhin sunshine at public.kherson.ua
Thu Jan 1 11:26:09 CST 2004


on 12/31/03 9:17 PM, Charles Yeomans at yeomans at desuetude.com wrote:

> Suppose I have a UShort field "amount" for which I want to compute a
> sum, as in
> 
> "SELECT SUM(amount) FROM TheTable".
> 
> It appears that the type of the field returned by the cursor may not be
> of type UShort.  Is there some rule as to what to expect?

Hi Charles,

Always

    uchar, ushort, ulong, ullong       -> ULLONG

           short, long, llong       -> LLLONG

    float, double                   -> DOUBLE


-- 
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://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------



More information about the Valentina mailing list