Home > Archive > PowerBuilder > February 2005 > Such a simple datawindow question...
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Such a simple datawindow question...
|
|
| Konstantin Goldobin 2005-02-05, 8:58 am |
| Hello G
Fri Feb 04 2005, G Wood wrote to All:
GW> Parent Child
GW> AAAA 1234
GW> AAAA 2343
GW> AAAA 4334
GW> BBBB 2222
GW> CCDD 3434
GW> The report should correctly count that there are 3 distinct parent
GW> values,
count(parent for all distinct parent)
GW> and 5 distinct child values.
count(child for all distinct child)
Konstantin.
http://www.vsi.ru/~kgold
| |
| G Wood 2005-02-08, 3:59 pm |
| Thanks Konstantin
I had tried the "distinct" clause previously, but I beleive I used
"count ( distinct parent for all )" and got a syntax error. I figured
distinct was not valid, and assumed I was pulling it from Oracle syntax.
Will try this idea as soon as I get to the office.
Tnx!
"Konstantin Goldobin" <Konstantin_Goldobin@p166.f3.n5025.z2.fidonet.org>
wrote in message
news:MSGID_2=3A5025=2F3.166=40fidonet_4204acb6@fidonet.org...
> Hello G
>
> Fri Feb 04 2005, G Wood wrote to All:
>
> GW> Parent Child
> GW> AAAA 1234
> GW> AAAA 2343
> GW> AAAA 4334
> GW> BBBB 2222
> GW> CCDD 3434
>
> GW> The report should correctly count that there are 3 distinct parent
> GW> values,
>
> count(parent for all distinct parent)
>
> GW> and 5 distinct child values.
>
> count(child for all distinct child)
>
> Konstantin.
> http://www.vsi.ru/~kgold
|
|
|
|
|