From: mark dot horwell at uhns dot nhs dot uk
Operating system: Windows XP
PHP version: 4.3.10
PHP Bug Type: ODBC related
Bug description: Deleteing From a MS Access Database using PHP
Description:
------------
When ever i try to delete a record with a MS access database I get the
following error message
Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Could not
delete from specified tables., SQL state S1000 in SQLExecDirect in
C:\Estates Info System\admin\Delete_Site.php on line 13
I know ther no problem with the sql statment, not sure what to do.
I am using PHP, IIS and MS access
Please Help
Reproduce code:
---------------
<?
$connect = odbc_connect ("Information_System","root","");
$query = "DELETE FROM Site WHERE(((Site.[Site Code])='076'))";
odbc_exec($connect, $query);
?>
Expected result:
----------------
Record with key 076 whould be deleted but is not
Actual result:
--------------
Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Could not
delete from specified tables., SQL state S1000 in SQLExecDirect in
C:\Estates Info System\admin\Delete_Site.php on line 13
--
Edit bug report at http://bugs.php.net/?id=32041&edit=1
--
Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=32041&r=trysnapshot4
Try a CVS snapshot (php5.0):
http://bugs.php.net/fix.php?id=32041&r=trysnapshot50
Try a CVS snapshot (php5.1):
http://bugs.php.net/fix.php?id=32041&r=trysnapshot51
Fixed in CVS: http://bugs.php.net/fix.php?id=32041&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=32041&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=32041&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=32041&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=32041&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=32041&r=support
Expected behavior: http://bugs.php.net/fix.php?id=32041&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=32041&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=32041&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=32041&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=32041&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=32041&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=32041&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=32041&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=32041&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=32041&r=nozend
MySQL Configuration Error: http://bugs.php.net/fix.php?id=32041&r=mysqlcfg
