🚀 go-pugleaf

On Sun, 10 Jan 1999 21:44:02 +0100, tt <thomas@trautwein.com> wrote:

>i am trying to calculate averages via sql. everything works fine except
>that all numbers in my answer-table are integers. sql rounds the results
>to integers.
>
>i tried to change the number-format of my source fields ("N", 2 digits),
>but this did not work.
>
>does anybody have an idea about that?

I have not heard of the BDE doing anything like this. Perhaps someone in
the dBASE area may be familiar with a situation like this. What is the
version of the BDE used? How does the same SQL statement function when
executed from a utility external to dBASE? (Like Database Desktop.)

What is the exact statement? What is the exact data type of the table
column being averaged?

One thing you might try doing is forcing the result of the averaging to be
in a specific data type, such as NUMERIC. Do this by applying the CAST
function to the result of the AVG function. For example:

  SELECT CAST(AVG(H.Pur_Price) AS NUMERIC(9, 2)) AS Avg_Price
  FROM "Holdings.dbf" H

//////////////////////////////////////////////////////////////////////////
Steve Koterski                      "I do most of my writing sitting down.
Technical Publications              That's where I shine."
INPRISE Corporation                         -- Robert Benchley (1889-1945)
http://www.inprise.com/delphi