Qualify / Expand wildcards / Lay out SQL

• 
  Hi Lumbago,
  
  We felt that we really should use square brackets as a safety measure for those who have used reserved words, spaces, etc in object names. We may implement your suggestion for an option to turn them off in future versions, but I am afraid that this will not make the v1.0 release.
  
  Sorry and hope you like the rest of the product.
  
  Regards,
  
  Jonathan

  JonathanWatts October 13, 2006 06:19

  - 0 +
• 
  I also vote for square brackets to be optional.
  
  Tim
  Denver, CO

  tgoldstein October 16, 2006 13:00

  - 0 +
• 
  This product is a step forward in the right direction. However, brackets simply have to be optional for us to use it. They clutter the code, making it practically impossible to read, and should not be used unless needed, or someone is crazy enough to put spaces in their object names.

  vkirkpat October 16, 2006 13:39

  - 0 +
• 

  Lumbago wrote:

  Don't know exactly where this fits in but when I qualify object names or expand wildcards it adds square bracets ( [ ] ) automatically. Is it possible to make these bracets an option? I never use them unless I come across a reserved word as a column/table name and that doesn't happen very often.

  
  This is something we were considering, and in the final release there will be an option. Use [] only if required (i.e. there are spaces or reserved keywords) and force [].
  
  Regards,
  Andras

  Andras B October 17, 2006 05:18

  - 0 +
• 
  Fantastic news

  Lumbago October 17, 2006 05:45

  - 0 +
• 
  Yes, most excellent Sir Andras. Thank you.

  vkirkpat October 17, 2006 07:33

  - 0 +

Add comment

Please sign in to leave a comment.