JayT
Posts: 14
|
| Posted: 10/16/2006, 4:24 AM |
|
Hi,
Been using codecharge 3.0 along with php 4. Been able to design various pages using this application connected to a ms access database.
all the other pages work fine accept the scoring page.
When i add a new record to the database it works fine, problem lies when i want to amend a record, i click submit and get an error
"Warning: odbc_exec(): SQL error: [Microsoft][ODBC Microsoft Access Driver] Cannot update 'ID'; field not updateable., SQL state 23000 in SQLExecDirect in c:\program files\easyphp1-8\www\newproject2\db_odbc.php on line 88"
along with below error on the form.
Database error: [Microsoft][ODBC Microsoft Access Driver] Cannot update 'ID'; field not updateable.
I understand that the problem is with the ID field i've checked the database and codecharge, all seems fine.
Can any one shed some light on this, your help would be appreciated
|
 |
 |
robertmann
Posts: 109
|
| Posted: 10/16/2006, 6:24 AM |
|
Most likely your ID field really is not updateable for example if it is an AutoNumber type field.
_________________
Robert |
|
|
|
JayT
Posts: 14
|
| Posted: 10/16/2006, 8:03 AM |
|
cheers robert, thanks for your help, its all sorted now.
|
|
|
|
|
