JW
|
| Posted: 04/11/2002, 2:08 AM |
|
Thanks Alex.
The sample in BookStore is not a good way. Because it re-run the sql again.
I want to simply use a variable in "Events" -> "Before Show" to collect the summary that I want.
But I don't know how and where to display that variable.
Help.
Thanks,
JosephWang
|
|
|
 |
Alex Alexapolsky
|
| Posted: 04/11/2002, 2:16 AM |
|
OK , then declare "total" variable in Form Open event ,
accumulate summary in it in Before Show event , like
total = total + fldprice
Put {mytotal} in Form/Footer
In Form Close event fill this template variable, e.g
SetVar "mytotal",total
|
|
|
|
JW
|
| Posted: 04/11/2002, 9:06 PM |
|
I did those procudures.
1.Put a variable in FORM/OPEN: vTotalQty=0
2.Accumulate: vTotalQty=vTotalQty+cDbl(fldTRANS_QTY)
3.Put {mytotal} in FORM/Footer
4.Put a line of code in FORM/CLOSE: SetVar "mytotal",vTotalQty
But why it still cannot display.
Please help.
Thanks,
JosephWang
|
|
|
|
Nicole
|
| Posted: 04/12/2002, 2:23 AM |
|
Hello,
try to print vTotalQty in before Show event to find is it accumulated. And in Close event to check its value. Is the printed values correct on each step?
|
|
|
|
Nicole
|
| Posted: 04/12/2002, 2:23 AM |
|
Hello,
try to print vTotalQty in before Show event to find is it accumulated. And in Close event to check its value. Is the printed value correct on each step?
|
|
|
|
JW
|
| Posted: 04/15/2002, 9:11 PM |
|
Thanks Nicole,
Yes,I printed out vTotalQty in Before Show, it displayed correct value.
But in Event->Close, displayed nothing....
Why?
|
|
|
|
Nicole
|
| Posted: 04/16/2002, 4:47 AM |
|
Hello,
the solution could be to put SetVar code right to Before Show event.
|
|
|
|
|
