Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Calculate total values when check column on grid is true
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01244964
Message ID:
01244985
Views:
33
>>Hello Naomy
>>
>>Your Question is :
>>Do you want to calculate totals for the whole grid or put totals in an extra column of the grid?
>>
>>i want to calculate , no on any column in my Grid but on a textbox in my form the value of the column , for example : €totalinvoice , where the grid column checkbox is true.
>>
>>for example
>>Columns on my grid : Check , nº invoice , totalinvoice
>>
>>check           nº invoice      totalinvoice
>>.T.             11111               1000,00
>>.T.             22222                500,00
>>.F.              3333                100,00
>>
>>my textbox total on my form outside the grid is equal to : (1000,00+500,00)=1500
>>
>>Thanks, i hope you understand better now.
>>
>>Luis Santos
>
>Sure, it's much better now.
>
>select MyTable
>sum TotalInvoice to lnTotal for Check = .t.
>thisform.txtTotal.value = m.lnTotal
I really hate this:
... for Check = .t.
There is no need for one additional comparison, why not just:
... for Check
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform