can't query on 'Order Details' table in Northwind

• VIJAYA SATISH KUMAR BODAPATI

  SSC-Addicted

  Points: 437

  More actions

  October 29, 2007 at 8:41 am

  #126421

  Hi all

  I faced a problem when using Northwind sample Database. On of the table in the database is 'Order Details'. I am unable to query on the table because of the space in the name ('Order' 'Details') of the table. When I remove the space in the name, the reports associated in Cognos are not working properly. Let me know whether there is any purpose to put the name like that and if I want to see the data in query mode how it is possible.

  Thanks in advance

  Satish

• Andras Belokosztolszki

  SSC-Insane

  Points: 21971

  More actions

  October 29, 2007 at 8:55 am

  #746275

  put brackets around the name, like:

  [Order Details]

  Regards,

  Andras

  ---

  Andras Belokosztolszki, MCPD, PhD
  GoldenGate Software

• VIJAYA SATISH KUMAR BODAPATI

  SSC-Addicted

  Points: 437

  More actions

  October 29, 2007 at 9:38 am

  #746292

  Thank you friend. You helped me to resolve my problem

  -Satish