求教高手:odbc更新数据出错# Database - 数据库
l*n
1 楼
数据库是access xp, 采用的是system dsn,其余都是缺省设置。
更新记录语句为:
update people set lastname='hhe', firstname='hehe', middlename='',
emailaddress='',
homepage='', institute='University', memo='' where peopleid=1
出错信息如下:
Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Operation must
use an updateable query.,
SQL state S1000 in SQLExecDirect in people_save.php on line 40
但是读取数据没有任何错误,请问可能是什么原因,怎么解决?谢谢
更新记录语句为:
update people set lastname='hhe', firstname='hehe', middlename='',
emailaddress='',
homepage='', institute='University', memo='' where peopleid=1
出错信息如下:
Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Operation must
use an updateable query.,
SQL state S1000 in SQLExecDirect in people_save.php on line 40
但是读取数据没有任何错误,请问可能是什么原因,怎么解决?谢谢