Page 1 of 1

Dynamic SQL Error -104

Posted: Wed Apr 20, 2011 12:55 pm
by Wanderer
Created a new database from the attached datafile 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.