Comments in query

I would love if it was possible to insert comments into a query, explaining why certain criteria was included. For example "The following OR statement was used to pull specific names per the President". Very typical to comment things in programming environments, so being able to explain queries would be wonderful!

  • Guest
  • Feb 12 2014
  • Attach files
  • Dariel Dixon commented
    February 27, 2019 16:54

    I love this idea, and more importantly the ability to comment out parts of the query while testing.  

    Attachments Open full size
  • Guest commented
    January 24, 2019 18:27

    I totally agree.  All query languages (e.g. SQL) or other high level languages (VB, VBA, C#, etc.) have the ability to put a comment in-line.  This makes the code/query much easier to decipher when looked at later or if worked on by some colleague long after the writer of the query has 'left the scene".  It is good programing style and a best practice that should be included in the RE query interface.  It would be easy to implement -- just have the interpreter ignore any lines with a comment e.g. REM This is a comment.  

    Attachments Open full size

Related ideas