What is the wrong in this code?

[sal1150]

I use this code in a class to insert row in table:-

'********************
Public Sub hosptINSERT(FRM As Object, C As Object)

Set Cmd = New ADODB.Command
With Cmd
.ActiveConnection = cn
.CommandText = "prd_insert_HOSPT"
.CommandType = adCmdStoredProc
.Parameters.Append .CreateParameter("@HOSPNAME_1", adVarChar, 1, 10, C(0).Text)
.Parameters.Append .CreateParameter("@FULLNAME_2 ", adVarChar, 1, 50, C(1).Text)
.Parameters.Append .CreateParameter("@AHOSPNAME_3", adVarChar, 1, 50, C(2).Text)
End With
End Sub
'********************
WHEN I TRAY TO RUN IT ,I FACE THES MSG:-'Must specify index for object array'

[Blobby]

which line does Debug give the error on?

[phinds]

you don't say what "cn" is. Is it an object array?

[sal1150]

The object array is c(0),c(1) and c(3)

[Blobby]

0, 1 and 3??

[sal1150]

So what can i do? How can i solve it? i need it to work in a class.

[andreys]

What is your code when you call this "hosptINSERT" sub?