Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Summing values in a Grid Column
Message
From
07/01/2005 23:33:40
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00975355
Message ID:
00975361
Views:
14
>Thanks for the quick reply!
>
>I actually want to leave the textbox stationary in the corner, i having the problem of calculating the total for the column values.
>
>I've tried setting the textboxes value to =sum(payments.amount) but this doesn't seem to work. I must be missing something simple...

Well, you don't have the kind of formulae you have in Excel. Some of your options for the actual calculation include:
calculate sum(payments.amount) to SomeVariable
or:
sum amount to SomeVariable
or:
select sum(amount) as amount from Payments into cursor Temp
... and then use the column Temp.Amount.

Another question is when this calculation should be triggered. This might be once on form startup (Form.Init()), or every time the user changes a value in the grid - the events in the latter case might be Valid() for each TextBox within the Columns, or Grid.AfterRowColChange(). The latter is simpler, but it will do the calculation even if no changes have been made.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform