hi,

i am using vb and storedprocedures., in vb adodb.command is used. i am inserting into a table using stored procedure. after inserting i want to return the inserted row to a recordset.

in a select storedprocedure the "set rs = command1.execute" works fine. but in a insert sp, after the insert statement any select statement is not considered. so in insert sp, "set rs = command1.execute" does not work. can anyone explain me why and is there any way to return the row in the insert sp itself.