Hi,

I m NOT using storedprocedure. I m using the ADO command object which will stored the compiled command text. I m passing only parameter value in UPDATE command text. And it doesn't return value or parameter.

How can i do this.

Pls see my command syntex below.

Set rsPending = New ADODB.Command

Set rsPending.ActiveConnection = cnnDefault

rsPending.CommandType = adCmdText

rsPending.CommandText = "UPDATE vTableServerAllocationView _

& " SET EG0_User='varUserid' OUTPUT INSERTED.Sr_No,INSERTED.Doc_No WHERE Sr_No =?"

rsPending.Parameters.Append rsPending.CreateParameter("SN", adDouble, adParamInput)

rsPending.Prepared = True