|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Updateable query error
I get this error:
operation must use an updateable query (line 43) on this code: ... 'Create the INSERT statement for a brand new client. SQLINSERT="INSERT INTO Clients (fname, lname, email, carID, tranID, gradeID) " SQLINSERT=SQLINSERT & "VALUES (" SQLINSERT=SQLINSERT & "'" & fname & "', " SQLINSERT=SQLINSERT & "'" & lname & "', " SQLINSERT=SQLINSERT & "'" & email & "', " SQLINSERT=SQLINSERT & carID & ", " SQLINSERT=SQLINSERT & tranID & ", " SQLINSERT=SQLINSERT & gradeID & ") " set connupdate = server.createobject("ADODB.Connection") connupdate.open "DNS=parking" connupdate.execute(SQLINSERT) ... Where line 43 is: connupdate.execute(SQLINSERT) any clues? Clients is the table name, parking is the odbc datasource name, etc. |
|
#2
|
|||
|
|||
|
Do you have the permisions to perform this action??
S- |
|
#3
|
|||
|
|||
|
May be the database is not given Write permissions to all it's users.Check that out.If permission is not given , give write permissions to all.
SQLINSERT=SQLINSERT & carID & ", " SQLINSERT=SQLINSERT & tranID & ", " SQLINSERT=SQLINSERT & gradeID & ") " are the above lines number fields? |
![]() |
| Viewing: ASP Free Forums > Database > SQL Development > Updateable query error |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|