|
Home > Archive > microsoft.public.cert.mcdba > June 2002 > 'compute' and 'compute by' in ADO programming
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 |
'compute' and 'compute by' in ADO programming
|
|
|
| As we know, SQL Server's compute and compute by in much powerful and
useful in generating reports. But I wonder how to utilize this in ADO
programming to fetch the data generated by these grammar.
| |
|
| Don't. Add the numbers up in your client application code or try the WITH
CUBE or ROLLUP options with the SQL GROUP BY clause.
COMPUTE data may be accessible with low level ODBC calls (or it may only
work with DBLIB), but I'm pretty sure it's unusable via ADO or even direct
OLE DB.
"Tommy" <tijian2001@21cn.com> wrote in message
news:#DoTRfjCCHA.1732@tkmsftngp02...
> As we know, SQL Server's compute and compute by in much powerful and
> useful in generating reports. But I wonder how to utilize this in ADO
> programming to fetch the data generated by these grammar.
| |
| Alan Davis 2002-06-23, 6:15 am |
| In ADO each part of the compute & compute by clauses are returned as
seperate recordsets, thus are fully available through ado by callling
the NextRecordset method. See KB article q194005 for an example.
On Sun, 2 Jun 2002 21:22:52 +0800, "Tommy" <tijian2001@21cn.com>
wrote:
>As we know, SQL Server's compute and compute by in much powerful and
>useful in generating reports. But I wonder how to utilize this in ADO
>programming to fetch the data generated by these grammar.
>
>
|
|
|
|
|