Hi Enrique,
Thanks for responding, later last night I found out the problem, here it is below in a short code:
*!* The following returns a sum of the previously saved values
*!* SELECT SUM(yAmount) AS ySum ;
*!* FROM v_sJVDr ;
*!* WHERE iPID = v_tJV.iID ;
*!* GROUP BY iPID ;
*!* INTO CURSOR Temp
*!* The following returns a sum of the currently entered values
SELECT v_sjvdr
lnrecno = recno()
SUM yAmount TO lySum
go (lnrecno)
The select statement created the problems, it somehow retrieves the older values and a simple sum will return the current values.
Any idea anyone what is happening?
Regards
Bhavbhuti
©2002 Bhavbhuti Nathwani |
