Steve1445
Posts: 16
|
| Posted: 06/21/2007, 8:16 PM |
|
Using this line in the before show event for a search result grid
CCDLookup("SUM(<priceamt>)", "<3a>", Empty, DB<Econ>)
Works fine but only shows (does not sum) the first row in the table not the all the rows in the grid, anyone care to tell me where I missed something?
field name is PriceAmt, table name is 3a, no where condition. Connection is Econ
Thank you
|
 |
 |
Joachim Uersfeld
|
| Posted: 06/21/2007, 11:12 PM |
|
Try it with the condition "1=1"
Joachim
Steve1445 wrote:
> CCDLookup("SUM(<priceamt>)", "<3a>", Empty, DB<Econ>)
>
> Works fine but only shows (does not sum) the first row in the table
> not the all the rows in the grid, anyone care to tell me where I
> missed something?
>
> field name is PriceAmt, table name is 3a, no where condition.
> Connection is Econ
|
|
|
|
Benjamin Krajmalnik
|
| Posted: 06/25/2007, 7:09 PM |
|
Can you be a bit more specific in what you are attempting to do?
This query will return a single value - the Sum of the column preiceamt in
table 3a.
Not knowing what you are trying to assign it to makes it difficult to point
you in the right directio.
"Steve1445" <Steve1445@forum.codecharge> wrote in message
news:6467b3ef531293@news.codecharge.com...
> Using this line in the before show event for a search result grid
>
> CCDLookup("SUM(<priceamt>)", "<3a>", Empty, DB<Econ>)
>
> Works fine but only shows (does not sum) the first row in the table not
> the
> all the rows in the grid, anyone care to tell me where I missed something?
>
> field name is PriceAmt, table name is 3a, no where condition. Connection
> is
> Econ
>
> Thank you
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.yessoftware.com/
>
|
|
|
|
Steve1445
Posts: 16
|
| Posted: 06/26/2007, 3:32 AM |
|
Thanks for you response I have since found out that the function was working correctly, it return just what you said. I was looking for a summing of all rows in the search result.
|
|
|
|
|
