On 9 Apr 2016, at 4:20pm, Richard Williams <richard at roguewavelimited.com>
wrote:
> The
> code was not deleting the expected rows ('abc' & 'def') because of the bad
> syntax. However the error did not throw an exception. Is this what I should
> expect?
There was no exception because SQLite successfully understood your command.
Your SQL command is actually legal. However if you inspect the properties of
$stat you should get some understanding of what went wrong.
PHP/SQLite3 tip:
If you want better integration with SQLite and aren't going to convert your
code to work with other SQL engines. it is far better to use PHP's own sqlite3
library rather than the generic PDO library. This gives you finer control over
SQLite's features and removes the need to learn both PDO and SQLite structures
and techniques. It's faster and keeps files locked for less time, too.
On the other hand, if you're using SQLite3 for testing only and your production
code is actually going to work on some other engine, you'll be better off as
you are using the PDO library.
Simon.
