Hi,

I'm trying out some few things about updating a database...

 $connection = odbc_pconnect("OpusDB","","",SQL_CUR_USE_ODBC);
// define the rows that are going to be extracted
          odbc_exec($connection,"UPDATE DeptMaster SET Counter=Counter+1
WHERE DeptDesc='$mydepartment'");

here's the error:

Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Operation must
use an updateable query., SQL state S1000 in SQLExecDirect in
c:\inetpub\wwwroot\TMPlvv9ya34u1.php on line 16

I am trying this out on an IIS in XP with the MSACCESS database...

Pls. help. Thanks.



-- 
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to