Gj
|
| Posted: 06/10/2002, 8:22 AM |
|
I found a bug in the count function in grid forms.
To count the number of records, codecharge replaces the part between
"select" and "from" with "select count(*) from"
Example:
"select articleid, title from articles where..."
->
"select count(*) from articles where..."
This works fine most of the time, but not when I add "distinct" to the
original query, assuming that I have some duplicate data:
"select distinct articleid, title from articles where..."
the result returned by "select count(*) from articles" is now greater
than the number of records returned by the original query.
gr gj
|
|
|
 |
Alexey Alexapolsky
|
| Posted: 06/12/2002, 2:38 AM |
|
Do you refer to CC or CCS ?
--
Alex
CodeCharge Developer
"Gj" <gj@schalk.triple-it.nl> wrote in message
news:ae2g82$e7q$1@news.codecharge.com...
> I found a bug in the count function in grid forms.
>
> To count the number of records, codecharge replaces the part between
> "select" and "from" with "select count(*) from"
>
> Example:
>
> "select articleid, title from articles where..."
> ->
> "select count(*) from articles where..."
>
> This works fine most of the time, but not when I add "distinct" to the
> original query, assuming that I have some duplicate data:
>
> "select distinct articleid, title from articles where..."
>
> the result returned by "select count(*) from articles" is now greater
> than the number of records returned by the original query.
>
> gr gj
>
>
|
|
|
|
Gj
|
| Posted: 06/12/2002, 2:58 AM |
|
To codecharge Alexey.
gr gj
"Alexey Alexapolsky" <alexa@codecharge.com> wrote in message
news:ae74pr$cm8$2@news.codecharge.com...
> Do you refer to CC or CCS ?
>
> --
> Alex
> CodeCharge Developer
>
>
> "Gj" <gj@schalk.triple-it.nl> wrote in message
>news:ae2g82$e7q$1@news.codecharge.com...
> > I found a bug in the count function in grid forms.
> >
> > To count the number of records, codecharge replaces the part between
> > "select" and "from" with "select count(*) from"
> >
> > Example:
> >
> > "select articleid, title from articles where..."
> > ->
> > "select count(*) from articles where..."
> >
> > This works fine most of the time, but not when I add "distinct" to the
> > original query, assuming that I have some duplicate data:
> >
> > "select distinct articleid, title from articles where..."
> >
> > the result returned by "select count(*) from articles" is now greater
> > than the number of records returned by the original query.
> >
> > gr gj
> >
> >
>
>
|
|
|
|
|
