Problem with calculated fields

Article View: borland.public.cppbuilder.database.ado

Article #998

Back to borland.public.cppbuilder.database.ado Previous Next

#998

From: AlexB
Date: Mon, 29 Nov 2004 09:27

24 lines
1757 bytes

Hi all!

BCB5+Up1

MS Access -- ADOConnection -- ADOQuery --
  DataSource -- DBGrid & DBNavigator

Query is:

Select  *,
  (3.14*Diameter*Diameter/4) as FaceArea,
  (3.14*Diameter*SideLength) as SideArea
  from ListTbl order by Number, Designation

Query has static fields FaceArea, SideArea, DBGrid has corresponding 
static columns. Then application starts I can see right values in both 
FaceArea and SideArea columns of DBGrid .

After refreshing: FaceArea column shows me values from Diameter (!?), 
SideArea nevertheless has right values ...

Is it known bug? Or some my mistake?

AlexB.

Technical Details

Message-ID: <41aaeb6f@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!proxad.net!gatel-ffm!gatel-ffm!194.25.134.126.MISMATCH!newsfeed01.sul.t-online.de!newsfeed00.sul.t-online.de!t-online.de!newsfeed.freenet.de!216.196.110.149.MISMATCH!border2.nntp.ams.giganews.com!border1.nntp.ams.giganews.com!nntp.giganews.com!pe2.news.blueyonder.co.uk!blueyonder!news-peer-test!btnet!newsfeed.bt.es!caladan.landsraad.net!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,14f1cefa54e637b5,start
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
Date: Mon, 29 Nov 2004 15:27:07 +0600
From: AlexB <b.a.v@inbox.ru>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.7.2) Gecko/20040804 Netscape/7.2 (ax)
X-Accept-Language: ru, en-us, en
MIME-Version: 1.0
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Problem with calculated fields
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 212.192.185.54
Message-ID: <41aaeb6f@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1101720431 212.192.185.54 (29 Nov 2004 01:27:11 -0700)
Lines: 24
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!proxad.net!gatel-ffm!gatel-ffm!194.25.134.126.MISMATCH!newsfeed01.sul.t-online.de!newsfeed00.sul.t-online.de!t-online.de!newsfeed.freenet.de!216.196.110.149.MISMATCH!border2.nntp.ams.giganews.com!border1.nntp.ams.giganews.com!nntp.giganews.com!pe2.news.blueyonder.co.uk!blueyonder!news-peer-test!btnet!newsfeed.bt.es!caladan.landsraad.net!newsgroups.borland.com!not-for-mail