At 04:40 PM 4/6/2011, Jim Belisle wrote:
Our office people like to use the WHERE builder for some items so I have that as an option. Within the last couple of months, the builder now only works when they type in the information. If they doubleclick the fields or the buttons, everything comes down into the builder window but the error comes up, "No rows available" when in reality the same information typed in brings up the information. We have the latest build of 7.6.
It's NOT a problem! When providing such option to end-users, you will have to teach them how to use WHERE Builder. Selecting wrong option and/or operator, and not providing the required data will generate such -ERROR- message. Click on [Test Clause...] button to verify the integrity (Syntax) of WHERE clause ... before processing your request. Take a close look at all options, before clicking on [OK] button, including: . WHERE Clause . GROUP BY Clause (if selected) . ORDER BY Clause (if selected) . HAVING Clause (if selected) Have you given them a quick lesson on how to use WHERE Builder? Have you seen what they are typing and/or selecting? A five minute tutorial will help avoid all -ERROR- messages! Very Best R:egards, Razzak.
