Dynamic SQL Error -104

Romcenter 4 support discussion. Please do not post roms requests or illegal links, posts will be deleted. After discussion in this forum, please report any new bugs here.

Moderator: Wanderer

Forum rules
No roms requests or illegal links
User avatar
Wanderer
Board master
Board master
Posts: 791
Joined: Wed Oct 03, 2001 10:37 am
Location: Milky way

Dynamic SQL Error -104

Post 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.