Declaring @variables in SQL connection string
Posted on 2004-09-03
When I try to write a record in the sql database, it tells me that I must declare the @variables eventhough the actual variable has been declared. Am I doing something wrong????? I thought it was supposed to substitue the actual value by using the @ sign??????
Here is what I have
Dim admDate As String..........I dimed all the other variables also just not the @variables
For r4 = 1 To 51
objCommand.CommandText = "Insert Into itemAnalysisDetail " & "(admDate, studentId, teacherId, objectiveNumber, itemCorrectResp, studentResp) " & _
"VALUES(@admDate, @studentId, @teacherId, @readingElaobj(r4), @readingElaItemCorrectRespArray(r4), @readingElaStudentRespArray(r4))"