Razzak, In response, the sales people are using the buttons on the WHERE builder correctly. I just did it myself and once again here is the problem:
If I type this into the WHERE window it works, BillToCompany CONTAINS 'RECREATION SERVICES' AND QuoteDate > 01012011 When using the buttons this is what is entered into the WHERE window: DistQuotes.BillToCompany CONTAINS 'RECREATION SERVICES' AND DistQuotes.QuoteDate > 01012011 This comes up with the messages, "No rows exit". The only difference is the buttons put in the view name before the column name. It is not entry person error because the software puts the view name in. As I said in the previous email, this just started after the last update in January. (7.6) James Belisle -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Wednesday, April 06, 2011 4:00 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Where builderm problem 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.
