Jump to content
Changes to the Jaspersoft community edition download ×

How to write sql statements with tables using reserved words


blackc2004

Recommended Posts

Hello,

I am trying to get started using iReport Designer and hopefully someone can help me out with this question. Our database is Microsoft Dynamics NAV and all the tables have special chars in them, such as this:

Company Name$Table Name

In SQL my query is SELECT * FROM [Company Name$Table Name]

However when I do this in iReport query it removes the brackets. How can I write queries with these special chars?

Link to comment
Share on other sites

  • Replies 3
  • Created
  • Last Reply

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...