Re: Problem with calculated fields

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

Article #999

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

#999

From: Viatcheslav V. Vassiliev
Date: Mon, 29 Nov 2004 10:34

37 lines
2098 bytes

Do you have ADOUpgrade1 installed? Try also BetterADODataSet from
http://betterado.hit.bg/ instead of TADOQuery.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

"AlexB" <b.a.v@inbox.ru> ???????/???????? ? ???????? ?????????:
news:41aaeb6f@newsgroups.borland.com...
> 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: <41aafb52@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!newsgate.cistron.nl!feeder1.cambrium.nl!news.cambrium.nl!npeer.de.kpn-eurorings.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <41aaeb6f@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,14f1cefa54e637b5
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Viatcheslav V. Vassiliev" <support@oledbdirect.com>
Newsgroups: borland.public.cppbuilder.database.ado
References: <41aaeb6f@newsgroups.borland.com>
Subject: Re: Problem with calculated fields
Date: Mon, 29 Nov 2004 13:34:57 +0300
Lines: 39
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
NNTP-Posting-Host: 213.234.218.42
Message-ID: <41aafb52@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1101724498 213.234.218.42 (29 Nov 2004 02:34:58 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!newsgate.cistron.nl!feeder1.cambrium.nl!news.cambrium.nl!npeer.de.kpn-eurorings.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message