Very Computer

1. Problem using shape recordsets with stored procedure that uses a temp table

Hello,

i use a stored procedure to get data. This sp uses a temporary table to get
the correct results. There is no problem with this sp retrieving the data
directly into an ado recordset, but if i want to use this sp in a shape
command the ODBC driver raises an error that he could not find the temporary
table.
In normal the temporary table is created in the sp and will be deleted after
executing them.

Is there anywhere a documentation on using temporary tables with a
hierarchical recordset, or better knows anybody the solution for this
problem.

The used shape command:
SHAPE {{ CALL sp_GetProductsByCategory (10,3,12) }} AS Products
APPEND ({{ CALL sp_GetMediaFiles() }} AS Mediafiles RELATE 'ProductID' TO
'ProductID') AS Mediafiles

The raised error:
Microsoft OLE DB Provider for ODBC Drivers: -2147467259
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
'#results'

Thanks a lot for reply
Ciao

2. Unable to open remote dump device

3. Problem: Recordset is closed after calling a stored procedure that uses temp tables

4. Views in SQL Server 7.0

5. Data shaping problem using stored procedures!

6. Check out DBMS World : http://home.wxs.nl/~agameren/dbms

7. insert into a global temp table using stored procedure

8. Precise/Indepth

9. Creating a Temp table using results from a store procedure

10. Some question about using temp table in stored procedure

11. ? about using temp tables in a stored procedure

12. Numerous deadlocks occurred involving Stored procedures using Temp tables