
Opening an ADO recordset against a dataset returned from a SQL Server Stored Procedure
Jim
1. One of the ways is to use the command object
With objCmd
.CommandText = "NameoftheSP""
.CommandType = adCmdStoredProc
'if there parameters append them
.Parameters.Append .CreateParameter("Address",
adVarChar, adParamInput, 50, txtBoxMinorAddress.Text)
End With
Set objRS=objCmd.Execute
--
Regards
Sukesh Hoogan
http://personal.vsnl.com/sukesh_hoogan
Quote:
> What SQL statement should I use to open a recordset returned by a SQL
Server
> stored procedure
> Current code:
> rst.Open "Exec ProcName, cnn, adOpenKeyset, adLockOptimistic
> This does not open the recordset.
> Jim B
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.471 / Virus Database: 269 - Release Date: 10/04/2003