Stored Proc with dataadpater

  • Thread starter Thread starter Stan Sainte-Rose
  • Start date Start date
S

Stan Sainte-Rose

Hello,

I have some problems with my Sql Stored Proc that use Temporary tables..
I get an Invalid Object Name #tbl when I use the SqlDataAdapter.
Need some help..
Thanks

Stan
 
If the SP created the #temp table, it was dropped when the SP ended.
hth

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
MVP, hRD
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Yes I know and I agree..
But it seems you can't use temporary tables with my own Stored Procedures.
I get an error when I try to use these Stored Procedures
Something like this : Invalid Object Name #tbl

Stan
 
Are you saying that you can't reference the #Temp table created in the SP by
the same SP? Let's see the code.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
MVP, hRD
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
I don't have any problems with the Stored Procedure itself..
It works fine using SQL 2000 and some asp scripts..

But when I try to use this same Stored Procedure with VB.Net using the
SqlDataAdpater Wizard,
vb.net (the wizard) displays an error.. like if it doesn't accept Temporary
Tables created in Sproc.

Stan
 
Ah. Now that's not surprising. I find the same thing when I challenge the
DACW. I suggest you code it by hand.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
MVP, hRD
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Back
Top