I first created the database with SQLite Administrator.
However, I found the problem - the syntax of this line:
Code:
query = "REPLACE INTO photos ( id, photodata ) VALUES ( 1, " & cmd.FileToBLOB( pfn ) & " ) WHERE ( id = 1 )"
is completely incorrect. No whereclause was required for this REPLACE INTO.
Gary
