Query Window, designer tab, WHERE clause construction, selecting columns

[Anonymous]

Hi,

When I right click on the WHERE funnel and select "add condition…", I get the "condition.edit" window as shown below. I can type in the schema.table.column names OK but it would be nice if I could click in that are and get a list of column names similar to the list I see when I select the 'filter' button in the query results window.

[cid:2830B048-E076-4C17-8FF6-A6E3BB74B887]

BTW, we've been looking for a replacement for Brio Query for years. SQLeo looks very promising.

Nice Work,

Thanks,

Randy

This electronic message contains information generated by the USDA solely for the intended recipients. Any unauthorized interception of this message or the use or disclosure of the information it contains may violate the law and subject the violator to civil or criminal penalties. If you believe you have received this message in error, please notify the sender and delete the email immediately.

[PAscal]

Hello,
there is an other way to add condition :

on graph
right click on expected column
add where condition
then the condition.edit box is opened with the corresponding column selected

tell us if enough or not
regards
PAscal