“error parsing the query…..” when reading a database

Support for DataSlave

Moderators: Tom, ian

“error parsing the query…..” when reading a database

Postby ian » Thu Sep 16, 2010 6:46 am

You may get an error when reading in a table from a database. The error is:

    “There is an error parsing the query. [Token line number, Token line offset,, Token in error,,]"
This is caused by a table column using a reserved name, for example a table called “User”. To work around this use SQl to read the table. You can enter SQL rather then select a table or view. For example to read in a table called User enter:

Code: Select all
Select * from [user]

This has been observed when using the MS SQL Read object, but is may also occur with other Read objects.
ian
 
Posts: 364
Joined: Sat Dec 18, 2004 8:13 am
Location: UK

Return to Support

Who is online

Users browsing this forum: No registered users and 2 guests

cron