HELP: temp table in procedure, and ADO recordset

HELP: temp table in procedure, and ADO recordset

Post by Philippe Berniar » Wed, 03 Mar 1999 04:00:00



I wrote a procedure like that :

declare procedure ...
as
        select ...
        into #temptable

        select ...
        from #temptable t, othertable o

When I run it from T-SQL, it works fine.
Using a recordset from VB, rs.open works fine, but after rs.open,
recordset seems to be closed.

Any idea is welcome.

P.Berniard - Acomis