Description Brian Payton 2010-09-13 05:07:45 EDT

The Criteria (Where clause) part of the SQL Query Builder UI has some very annoying behavior.  For example, if you have a statement with a Where clause like this:

  WHERE Col1 = 'Foo'

The Criteria grid has the three columns Column, Operator, and Value showing Col1, =, and 'Foo' respectively.  If you click on any of those columns in order to edit the value, the value disappears.  This is annoying for any of those columns but is particularly so in the case of the Value column, since you might want to edit the current value, for example changing 'Foo' to 'Foot'.  Since the value blanks out, you need to type the entire value again.

This becomes downright obnoxious if you have an EXISTS predicate.  The entire subquery of the EXISTS predicate goes in the Value column, but you can't edit it.  The user is forced to edit the expression in the SQL source view.