How do I create a custom aggregate functions in Visual foxpro?

Question

Such as an aggregate product function...

For example,

an aggregate function in SQL would be SUM(colname) which would do an aggregate sum of all of the rows in the column. I want to be able to do my own that will aggregate with product using foxpro.

Answer 1

if u have a dbf with the following records

name basic da hra gross pf net
mandakini 5000 2000 1000 8000 800 7200
raveena 7000 3000 2000 12000 1200 10800
kiran 6000 1000 500 7500 750 6750

then sum basic to x
? x
resut - 18000

sum da to y
? y
resut - 6000

sum hra to z
? z
result - 3500

sum gross to a
? a
result - 27500

sum pf to b
? b
result - 2750

sum net to c
? c
result - 24750


u can also pass field as a parameter to function(user defined) and use that function.

Answer 2

Create a module. Inside a mudule create the function. You can call the finction with required parameters from anywhere.