Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #1872

Re: Calculate a total in bBrowser3 for a VirtualFieldColumn

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>

Show all headers | View raw


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


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