There exists an know bug with ODBC that generates SQL STATE S1000 (== General Error). I think a workarounds can be found (somewhere) at www.MSDN.com.
> -----Original Message----- > From: Apollo [mailto:[EMAIL PROTECTED]] > Sent: Monday, February 10, 2003 10:05 AM > To: [EMAIL PROTECTED] > Subject: [PHP-WIN] newbie:sql update > > > 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 > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
