Dynamic SQL Error -104

Romcenter 4 support discussion. Please do not post roms requests or illegal links, posts will be deleted.

Moderators: Wanderer, Logiqx, Iron Man

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

Dynamic SQL Error -104

Post by Wanderer » Wed Apr 20, 2011 12:55 pm

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

For Romcenter bug reporting or enhancement requests, click here.

Who is online

Users browsing this forum: No registered users and 5 guests