-
PROBLEM WITH ADO RECORD. A STORED.PROC. WITH INSERTS.
FIRST: SORRY FOR MY ENGLISH.
SECOND:
I WANT TO OPEN A RECORDSET THAT CALL TO STORED PROCEDURE
THAT INSERT INTO A TEMPORAL TABLE
THE SCRIPT IS like this:
Create proc xx
as
Create table #A(b int)
Insert into #A values(2)
Insert into #A values(3)
Select * from #A
and in VB I call this SP WITH THIS CODE:
'ADOCONECT IS MY CONNECTION
RSAUX.Open "XX",ADOCONECT,adOpenForwardOnly,adLockRea dOnly
AND I CAN'T USE THE RECORDSET BECAUSE IT'S CLOSE. IT'S GIVE ME THE ERROR
"The operation requested by the application is not allowed if the object is closed."
I PROVE WITH TEH OBJECT COMMAND AND ALL OF POSIBILITES THAT I kNOW.
CAN YOU HELP ME??
THANK YOU VERY MUCH
-
PROBLEM WITH ADO RECORD. A STORED.PROC. WITH INSERTS. (reply)
Hi Marcelo,
I think you need to post this message on the ASP forum. This one's devoted to support of ASP-db - a product which does all the work of opening recordsets and calling stored procedures, and displaying the data for you. Check it out at www.aspdb.com. Thanks and good luck,
John
------------
MARCELO SASSONE at 4/27/99 6:38:48 PM
FIRST: SORRY FOR MY ENGLISH.
SECOND:
I WANT TO OPEN A RECORDSET THAT CALL TO STORED PROCEDURE
THAT INSERT INTO A TEMPORAL TABLE
THE SCRIPT IS like this:
Create proc xx
as
Create table #A(b int)
Insert into #A values(2)
Insert into #A values(3)
Select * from #A
and in VB I call this SP WITH THIS CODE:
'ADOCONECT IS MY CONNECTION
RSAUX.Open "XX",ADOCONECT,adOpenForwardOnly,adLockRea dOnly
AND I CAN'T USE THE RECORDSET BECAUSE IT'S CLOSE. IT'S GIVE ME THE ERROR
"The operation requested by the application is not allowed if the object is closed."
I PROVE WITH TEH OBJECT COMMAND AND ALL OF POSIBILITES THAT I kNOW.
CAN YOU HELP ME??
THANK YOU VERY MUCH
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|