John Topley's Knowledgebase

Using Stored Procedure Output Parameters With ADO

Friday, 30 May 2003

This Visual Basic code illustrates the use of ADO output parameters with SQL Server stored procedures using Visual Basic 6.0.

• comCommand is a variable holding a reference to an ADO Command object.
• intReturn is an integer variable.
• Return is the SQL Server output parameter name.

.Parameters.Append .CreateParameter("Return", adInteger, _
  adParamOutput, , intReturn)
intReturn = comCommand.Parameters.Item("Return")

top | index | previous | next | comments ()