Page 1 of 1

Why it shown "Operation must use an updateable query&qu

Posted: Fri Apr 11, 2003 5:49 am
by notehaha
I've a problem, please help me.

Previously, I can use my php script correctly.
After I install VS.net, the script can't use.
It shown

"Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query., SQL state S1000 in SQLExecDirect in D:\NE_Web\Website\LANShop\LS_DM.php on line 62"

The source code as same as before.
Others script without UPDATE,INSERT,DELETE SQL instruction is OK, but the script that include the instructions will error like I wrote above.

SO, I format and install WinXP OS + SP1 again, but the script are error again.

I don't know how to do. I already checked the readonly DNS.

MY system:
PentiumIV 2.5
512MB RAM
WINDOWS XP SP1,
PHP4.3