SQL returns only integers

Article View: borland.public.vdbase.data.sql

Article #215

Back to borland.public.vdbase.data.sql Previous Next

#215

From: tt
Date: Sun, 10 Jan 1999 00:00

11 lines
824 bytes

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?

thanking you in advance,
thomas trautwein

Technical Details

Message-ID: <36991111.F42B21F0@trautwein.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,fc8f9f82181d59ea,start
X-Google-Attributes: gidff5a1,public
From: tt <thomas@trautwein.com>
Subject: SQL returns only integers
Date: 1999/01/10
Message-ID: <36991111.F42B21F0@trautwein.com>
X-Deja-AN: 430992819
Content-Transfer-Encoding: 7bit
Organization: Another Netscape Collabra Server User
Content-Type: text/plain; charset=us-ascii
Mime-Version: 1.0
Newsgroups: borland.public.vdbase.data.sql