PRB: Recordset DTC with COMPUTE Statement Returns Error 80040e21

MORE INFORMATION

Steps to Reproduce Behavior

1. Create a SQL statement or stored procedure that uses the COMPUTE statement, such as the Pubs stored procedure reptq1:

         CREATE PROCEDURE reptq1 AS
         select pub_id, title_id, price, pubdate
         from titles
         where price is NOT NULL
         order by pub_id
         COMPUTE avg(price) BY pub_id
         COMPUTE avg(price)
   						

2. Bind a Recordset DTC to the SQL statement or stored procedure.
3. Bind the Grid DTC to this Recordset DTC and have the Grid DTC return the pub_id, title_id, price, and pubdate columns.
4. Preview this page in your Web browser.