Input SQL Expression parameter

Discussion created by darinatch on Apr 11, 2011
Hello everyone,

I am just learning how to create tools, and I am having a little problem with adding a SQL Expression as an input parameter.
I want to create a tool to let the more advanced users build the where clause of the Make Query Table tool.

In ModelBuilder everything works fine, and when I click on the SQL button of my SQL Expression parameter, all the fields are populated, and i can build the expression. But when i want to run the tool in ArcCatalog by double clicking the tool, the Build Query window has no fields populated, and the user cannot build the expression.
What am I missing?

Thank you!