Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to put running balance in local view?
Message
From
28/04/1999 17:44:04
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00212879
Message ID:
00213216
Views:
33
>I usually do not setup the view for it - I put the code like this into textbox.Refresh()
>
>LOCAL array laTotal[1]
>laTotal[1] = 0
>SELECT SUM(amount) FROM myView as Total
>INTO array laTotal
>this.value = laTotal[1]
>
>Just my 0.02c CDN :)
>
>Nick

Nick, I need a running total on the right side of my detail grid. I already have code nearly identical to yours to calculate the final total in a method called GetAITEMS(). Am I missing something here?

Peter
Peter Robinson ** Rodes Design ** Virginia
Previous
Reply
Map
View

Click here to load this message in the networking platform