Hi, DJ
I try the following code:
------
try{
$dsn = 'sqlite:counter/cntdata.sq3';
$myConn = new PDO($dsn);
$myConn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$j = $myConn->exec('update test_item set balqty = 100');
}catch (PDOException $e){
die('execute err: '.$e->getMessage());
}
print("$j records are done!");
------
And the error message is:
"execute err: SQLSTATE[HY000]: General error: 8 attempt to write a readonly
database"
So the problem is why the database becomes read only.
Jack
