Calculating fields

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

Article #914

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

#914

From: Michele Santucci
Date: Wed, 02 Mar 2005 13:48

36 lines
1934 bytes

Hello NG,

I have a master record with these fields:
    IDLocation
    Latitude
    Longitude
    Seastate
    Surface

and a detail record with these fields:
    IDLocationLayer
    IDLocation
    Depth
    Temperature
    Salinity

I would like to add 3 fields to the master record:
    MaximumDepth (Max Depth among relative details fields)
    AverageTemperature (Average temperature among  relative details fields)
    AverageSalinity (Average salinity among  relative details fields)

I tried adding a Calculated Field to the master adodataset but I noticed 
that
if I move the cursor on a different record the underlying detail dataset is 
not
updated before the OnCalcField event is raised... how can I manage this????
-- 
Michele Santucci
===================
Celin Avio S.r.l.
Software Dev. Manager
--------------------------------------
tel. +390187564080
Via Fontevivo 21/M
19126 La Spezia
===================

Technical Details

Message-ID: <4225c414$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!zen.net.uk!dedekind.zen.co.uk!news-out.newsgroups.com!propagator2-sterling.newsfeeds.com!news-in.nuthinbutnews.com!news-in.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,80bc4e88fa6714e7,start
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Michele Santucci" <michele.santucci@celinavio.it>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Calculating fields
Date: Wed, 2 Mar 2005 14:48:05 +0100
Lines: 38
Organization: Celin Avio S.r.l.
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 62.94.122.236
Message-ID: <4225c414$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1109771284 62.94.122.236 (2 Mar 2005 05:48:04 -0800)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!zen.net.uk!dedekind.zen.co.uk!news-out.newsgroups.com!propagator2-sterling.newsfeeds.com!news-in.nuthinbutnews.com!news-in.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail