Keywords In SQL Field Names

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
PLawCoder
Posts: 1
Joined: Mon 28 Oct 2013 19:22

Keywords In SQL Field Names

Post by PLawCoder » Mon 28 Oct 2013 19:24

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?

AndreyZ

Re: Keywords In SQL Field Names

Post by AndreyZ » Tue 29 Oct 2013 08:25

Hello,

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

Post Reply