A
andyalean
Guest
Hello I have a problem with an insert query being said to have update properties.I am using asp page to to insert the data.
I get this error
Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.
/Assignment 1/verifyNewRegisterStudent.asp, line 191
My database table has an autonumber PK and one column with a default value.
I don`t know why an insert could not take place?
When I test the query in sql window of access I could actually insert a few records but not in testing from asp.Please view my sql of asp page.
sqlDsuAddStdMemb = "INSERT INTO dsu_Members (Campus_Code, Member_MemberCategory, Member_FirstName,"
sqlDsuAddStdMemb = sqlDsuAddStdMemb & " Member_LastName, DsuUnit_Code, Member_SessionID,"
sqlDsuAddStdMemb = sqlDsuAddStdMemb & " Member_Username, Member_Password)"
sqlDsuAddStdMemb = sqlDsuAddStdMemb & " VALUES ("&stdCampusCode&", '"&membCaty&"',"
sqlDsuAddStdMemb = sqlDsuAddStdMemb & " '"&stdFirstName&"', '"&stdLastName&"',"
sqlDsuAddStdMemb = sqlDsuAddStdMemb & " "&stdDsuUnitCode&",'"&sessionID&"',"
sqlDsuAddStdMemb = sqlDsuAddStdMemb & " '"&stdDsuUserName&"', '"&stdDsuPass1&"')"
Thanks for your help
I get this error
Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.
/Assignment 1/verifyNewRegisterStudent.asp, line 191
My database table has an autonumber PK and one column with a default value.
I don`t know why an insert could not take place?
When I test the query in sql window of access I could actually insert a few records but not in testing from asp.Please view my sql of asp page.
sqlDsuAddStdMemb = "INSERT INTO dsu_Members (Campus_Code, Member_MemberCategory, Member_FirstName,"
sqlDsuAddStdMemb = sqlDsuAddStdMemb & " Member_LastName, DsuUnit_Code, Member_SessionID,"
sqlDsuAddStdMemb = sqlDsuAddStdMemb & " Member_Username, Member_Password)"
sqlDsuAddStdMemb = sqlDsuAddStdMemb & " VALUES ("&stdCampusCode&", '"&membCaty&"',"
sqlDsuAddStdMemb = sqlDsuAddStdMemb & " '"&stdFirstName&"', '"&stdLastName&"',"
sqlDsuAddStdMemb = sqlDsuAddStdMemb & " "&stdDsuUnitCode&",'"&sessionID&"',"
sqlDsuAddStdMemb = sqlDsuAddStdMemb & " '"&stdDsuUserName&"', '"&stdDsuPass1&"')"
Thanks for your help