Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to cumulate totals of my view without loosing cur. r
Message
From
05/11/1999 10:37:49
 
 
To
05/11/1999 07:08:04
Rex Mahel
Realm Software, Llc
Ohio, United States
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00286872
Message ID:
00287527
Views:
18
>Bob,
>
>PMFJI, but if you are using buffering, your lnRecNo > 0 will not work if you add any records, the record numbers are negative.
>
>Rex
>

Your right... change it to lnRecno <> 0.... sorry!!!

BOb





>>>I have a view that I use to input data in a grid. In the amount field, valid method, I want to recalculate the totals by cumulating the amount in each record of the current view. The problem is that it makes me loose my current pointer.
>>>
>>>How can I achieve this?
>>>Thanks
>>>Eric
>>
>>
>>selec MyView
>>lnREcNo = RecNo()
>>
>>calculate sum(Field1), Sum(Field2), Avg(Field2) to ;
>>   sum_Field1, sum_field2, avg_Field2
>>
>>if lnRecno > 0
>>   go lnRecno
>>endif
>>
>>
>>BOb
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform