Article View: borland.public.interbase.sql
Article #770Re: Computed fields
From: Moore
Date: Thu, 28 Jun 2007 10:49
Date: Thu, 28 Jun 2007 10:49
14 lines
1666 bytes
1666 bytes
how can this be done? i do it but it shows me the sum for the first record in all records, how to refer to the actual record and actual table in the expression? can you give an expample? Wayne Niddery [TeamB] escribi๏ฟฝ: > As long as you are computing values from fields within the record being > selected there shouldn't be. > > However it's possible to select from other tables, e.g. you could add a > computed field in an Order record that sums the amounts from all its > OrderLine records. That means, on selecting that field from Orders, IB will > be performing that additional query for every selected Order row. >
Technical Details
Message-ID:
<46839253$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newspeer1.nwr.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mailReferences:
<4680da48@newsgroups.borland.com> <46825418$1@newsgroups.borland.com> <46828329$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 114a0e,eaa295f7e4d91326 X-Google-Attributes: gid114a0e,public,usenet X-Google-Language: ENGLISH,ASCII Date: Thu, 28 Jun 2007 12:49:57 +0200 From: Moore <delfino03@caramail.com> User-Agent: Thunderbird 2.0.0.0 (Windows/20070326) MIME-Version: 1.0 Newsgroups: borland.public.interbase.sql Subject: Re: Computed fields References: <4680da48@newsgroups.borland.com> <46825418$1@newsgroups.borland.com> <46828329$1@newsgroups.borland.com> In-Reply-To: <46828329$1@newsgroups.borland.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit NNTP-Posting-Host: 194.237.142.3 Message-ID: <46839253$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1183027795 194.237.142.3 (28 Jun 2007 03:49:55 -0700) Lines: 14 Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newspeer1.nwr.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail X-Original-Bytes: 1513