Devart Forums

Hello,

I have a SQL 2005 database with a table named USER. When I use the TMSTable component and try to connect to this table, I get the following error:

Incorrect syntax near the keyword 'User'.

I am assuming this is because User is a SQL Keyword, however, I would think it is also very common to name a table USER.

Any suggestions? This is an existing production application so I do not have the option of renaming the table.

Doug Olson

Please set the TMSTable.Options.QuoteNames to True.

Your suggestion still does not work... My only option is to use a TMSQuery component and construct the individual SQL myself... (much work since the User table changed recently)

Doug

We have reproduced this problem. The investigation of the problem is in progress. As soon as we solve it, we will let you know.

We have fixed this problem. This fix will be included in the next SDAC build. Please watch for announcements at the forum.

I am using SDAC 5.10.8.0 for Delphi 7 Trial and the same error appears
was it realy fixed or am I doing something wrong?

Please ignore the previous post, TMSTable.Options.QuoteNames does work