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
