Skip to main content

Turn On Lookup Queries

  1. Last updated
  2. Save as PDF

"Show Me The LOOKUP QUERIES"

As many of you know when a form is opened in Tier a number of lookups will fire the select statements assigned to them in the lookup properties. This occurs when you open the Client

A result of this issue is when the form is opened it quickly closes without user interaction. Since this typically occurs because of a "bad" lookup query statement; a nice way to determine the offending lookup quickly is to turn on the "Show Lookup Queries" option in your workstation properties.

Launch TIER and right click on "This Workstation" and select properties. Click on the Security/Debug tab.

By default this option is located at the bottom should be unchecked.

Lookup1.png

                                                          

After checking this option go back into the Tier Application and attempt to open the same form you were having trouble with earlier. Notice now that you can actually see each lookup query as it fires.

 

Lookup2.png

You can save each query as you go; choosing close will move you onto the next lookup. The last lookup to fire before the form crashes is the offending lookup. You can take that query and run it in SQL Query Analyzer to help weed out where the problem might be. It could simply be incorrect SQL syntax or possibly an improperly qualified table name or even an attempt to look for a field that doesn’t exist in that table.

So again, use this tool for troubleshooting forms that won’t open, listviews that don’t populate or any other function in Tier that utilizes the Tier Lookup control.