Page 1 of 1

Keywords In SQL Field Names

Posted: Mon 28 Oct 2013 19:24
by PLawCoder
Hi,

We recently purchased SDAC and we're attempting to use your objects on our database. In one of our statements, however, we're running into an issue with the keywords print and from. We basically receive an error stating that it is unable to parse 'print' or 'from'.

The issue is that, due to some legacy code, we cannot rename the column to something better.

We're using your TMSQuery object.

So what can we do about this?

Re: Keywords In SQL Field Names

Posted: Tue 29 Oct 2013 08:25
by AndreyZ
Hello,

To solve the problem, you should set the TMSQuery.Options.QuoteNames property to True.