Operation must use an updateable query?? help.!
| From: | Thiva Charanasri | Date: | Tue, 26 Jun 2001 10:38:47 +0000 |
| Subject: | Operation must use an updateable query?? help.! | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-55228@lists.php.net to get a copy of this message | ||
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-