Dynamic SQL Error -104

[Wanderer]

Created a new database from the attached datafile

Commodore Amiga - Firmware (TOSEC-v2006-06-25_CM).zip

(5.71 KiB) Downloaded 2837 times

While adding a path with various files in it (also contained many files irrelevant to the datafile), i received the following error in the log:

Code: Select all

Add new rom path
Add rom path <MyPath>
Loading 508 files in DB
Error :Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 384
s
Invalid token

GDS Code: 335544569Error Code: 249
200 files loaded
Error :Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 392
N
Invalid token

GDS Code: 335544569Error Code: 249
400 files loaded
508 files loaded
Analyse new files
Updating games status
Status updated for 109 items.
Green games : 89, yellow games : 0, red games : 20
Updating fileslist
  Query Paths list
Execution time: 0h 0m 15s

EDIT: After some tests, I found out it was caused by a single quote in a filename.