Andy H
|
| Posted: 04/28/2002, 8:51 PM |
|
Using the bookstore example, I have created a form that has a seach form, record grid form and then a total form. My problem is getting the SQL that is used in the total form, to be able to use the $sWhere that is generated out of the search form. It appears that $sWhere is always being initialized, so when I try to use it, it's blank.
What's the trick that I'm missing?
Thanks,
Andy
|
|
|
 |
Nicole
|
| Posted: 04/29/2002, 4:36 AM |
|
Andy,
to make total form display the real number of records found it should has the same WHERE clause as result grid form. If you're using CC just add Input parameters to Total form. In case you're working with CCS input parameters are to be added Data Source window (click on form, go to Properties window/Data tab and click on Data Source field).
|
|
|
|
Andy H
|
| Posted: 04/29/2002, 5:03 AM |
|
Nicole,
I'm not summing the number of records, but summing a column (hours) and need that total. Would input parameters enable that to work?
Andy
|
|
|
|
Nicole
|
| Posted: 04/29/2002, 7:06 AM |
|
Andy,
in for Open event declare lets say $total variable and add field value to it in Before Show event. Then you'll be able to display it e.g. in form's footer
|
|
|
|
|
