Feature request, missing feature and a bug

• 
  Hi Andy,
  
  

  AndyScott wrote:

  The ability to specify the alias for a table would be really useful as the auto selected aliases do not match the aliases used throughout my companies code base which makes reading the SQL difficult as I am used to certain aliases meaning specific tables.

  
  I think we're probably going to end up doing something about this for the final release as you're not the only person to have asked about it.
  

  The option to auto capitalise sql reserved words is gone in Version 3.

  
  Yeah, but it's only a temporary absence. It'll be back for the final release.
  

  The following SQL brings up the wrong candidate list
  
  select * from table1 AS t where t.Deleted='Y' and
  
  I would of expected the candidate list to of contained the fields in table1 as happened when bringing up the candidate list after the where clause but the candidate list appeared with tables listed instead of fields.

  
  Yep, that's a bug, although this had been working so I suspect I probably broke something at the last minute before the beta. Apologies for the hassle.
  
  
  Thanks,
  Bart

  Bart Read September 04, 2006 12:57

  - 0 +
• 
  Hi Bart, I forgot to say I am running SQL promp3.0 in Query Analyser.
  
  Andy

  AndyScott September 04, 2006 13:01

  - 0 +
• 
  Thanks for that Andy. I think you'd find the same issues in SSMS in this case.
  Cheers,
  Bart

  Bart Read September 04, 2006 14:01

  - 0 +

Add comment

Please sign in to leave a comment.