[PHP] Operation must use an updateable query?? help.!

[Thiva Charanasri]

Dear All PHP Gurus.

 

   I have problem with UPDATE query , I am using PHP on win2k connect to an ODBC connection,

 

I got error like this when update the DB.

 

 

 

Warning:  SQL error: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query., SQL state S1000 in SQLExecDirect

 

 

 

My SQL string is as below

 

$tmp_sbj=odbc_result($res2,"ART_SBJ");
$tmp_id=odbc_result($res2,"ART_ID1");
 
$sqlup="update article set  ART_SBJ='$tmp_sbj'   WHERE ( ART_ID1='$tmp_id')  ";
$res3=odbc_exec($fn,$sqlup);

 

thanks for any help!...

 

Sincerely,

-TC-