Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #1872
| From | Joachim Bieler <support@votools.com> |
|---|---|
| Newsgroups | comp.lang.clipper.visual-objects |
| Subject | Re: Calculate a total in bBrowser3 for a VirtualFieldColumn |
| Date | 2011-08-24 08:04 +0200 |
| Message-ID | <9bjiieFdofU1@mid.individual.net> (permalink) |
| References | <7dfe0be5-0fde-4c84-8a61-93a7ed442bb3@l8g2000prd.googlegroups.com> |
Grant,
you can determine the values of the virtual field column with the access
bVirtualFieldColumn:DataList. See topic 'bVirtualFieldColumn:DataList' in the bBrowser help for more
information. With the following code fragment you can determine the total.
iTotal := 0
auData := oVirtualFieldColumn:DataList
iCount := oVirtualFieldColumn:DataCount
FOR iPos := 1 UPTO iCount
iTotal += auData[iPos, BVFCD_VALUE]
NEXT
Regards,
Joachim Bieler
Am 23.08.2011 05:03, schrieb Grant:
> I would like to total the values from a VirtualFieldColumn to display
> at the end of a display but I don't know see how to do this. I have
> tried the Sum() method by using the generic virtual value #expression
> but that dosen't work so I have been looking for a sample with
> something like this but so far been unsuccessful. Any help would be
> appreciated. Thank you
Back to comp.lang.clipper.visual-objects | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
Calculate a total in bBrowser3 for a VirtualFieldColumn Grant <grantd@dunsmoreinfo.com> - 2011-08-22 20:03 -0700
Re: Calculate a total in bBrowser3 for a VirtualFieldColumn "Stephen Quinn" <stevejqNO@bigpondSPAM.net.au> - 2011-08-23 17:31 +1000
Re: Calculate a total in bBrowser3 for a VirtualFieldColumn Grant <grantd@dunsmoreinfo.com> - 2011-08-23 09:35 -0700
Re: Calculate a total in bBrowser3 for a VirtualFieldColumn "Stephen Quinn" <stevejqNO@bigpondSPAM.net.au> - 2011-08-24 10:38 +1000
Re: Calculate a total in bBrowser3 for a VirtualFieldColumn Grant <grantd@dunsmoreinfo.com> - 2011-08-24 15:16 -0700
Re: Calculate a total in bBrowser3 for a VirtualFieldColumn "Stephen Quinn" <stevejqNO@bigpondSPAM.net.au> - 2011-08-25 10:30 +1000
Re: Calculate a total in bBrowser3 for a VirtualFieldColumn Karl Faller <k.faller_withoutthat_@onlinehome.de> - 2011-08-25 10:09 +0200
Re: Calculate a total in bBrowser3 for a VirtualFieldColumn "Simon Goodman" <simon.spam@spam.abersoftware.co.uk> - 2011-08-25 12:48 +0100
Re: Calculate a total in bBrowser3 for a VirtualFieldColumn Grant <grantd@dunsmoreinfo.com> - 2011-08-25 12:25 -0700
Re: Calculate a total in bBrowser3 for a VirtualFieldColumn "Stephen Quinn" <stevejqNO@bigpondSPAM.net.au> - 2011-08-26 09:43 +1000
Re: Calculate a total in bBrowser3 for a VirtualFieldColumn Joachim Bieler <support@votools.com> - 2011-08-24 08:04 +0200
Re: Calculate a total in bBrowser3 for a VirtualFieldColumn "richard.townsendrose" <richard.townsendrose@gmail.com> - 2011-08-24 02:09 -0700
Re: Calculate a total in bBrowser3 for a VirtualFieldColumn Joachim Bieler <support@votools.com> - 2011-08-25 07:21 +0200
Re: Calculate a total in bBrowser3 for a VirtualFieldColumn Grant <grantd@dunsmoreinfo.com> - 2011-08-24 15:18 -0700
csiph-web