Page 1 of 1

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

PostPosted: Thu Sep 16, 2010 6:46 am
by ian
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.