Can memory variables in the vb program have the same name as field names in the tables?
Posted on 2004-09-03
I have Dimed all my variable names with the same names as my field names. Now, when I try to write the record is gives me this error message.
The name admDate is not permitted in this context. Only contraints, variables, or expressions are allowed here. Column names are not permitted.
Here is the code
For m4 = 1 To 60
objCommand2.CommandText = "Insert Into itemAnalysisDetail " _
& "(admDate, studentId, teacherId, objectiveNumber, itemCorrectResp, studentResp) " & _
"VALUES(admDate, studentId, teacherId, mathobj(m4), mathItemCorrectRespArray(m4), mathStudentRespArray(m4))"