Mike, You have been a great help! When I see the code, I understand what is happening. I just have a hard time putting code together myself. I do not program enough to learn the language. It is like trying to speak another language only periodically through the year. You never master it.
I ended up with the code below because I wanted the information brought up in another form. CHOOSE vchoice FROM #WHERE IN DistQuotes SET VAR vcount INTEGER = 0 SELECT COUNT (*) INTO vcount IND vin0 FROM DistQuotes &vchoice IF vcount > 0 THEN BROWSE USING DistQuoteScroll &vchoice ELSE PAUSE 2 USING 'No Matching Records Found!' ENDIF Thanks again. Jim -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of MikeB Sent: Saturday, April 11, 2009 12:45 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Button fro the Where builder Jim, The first line using the choose: CHOOSE vchoice FROM #WHERE IN DistQuotes Your users would make the column and criteria selection using the Where Builder form that comes up. After clicking OK on the Where Builder, your variable vChoice would contain the TEXT representing all the selection criteria. Not having the table structure of your DB to relate to, I can only show an example based on the ConComp Sample RRBYW14 where I want to browse all the customers in the Customer table with CustID between 100 and 120, so I would have a like like: cho vchoice from #where in customer I would select CustID as the column, then BETWEEN as the criteria, and then I would manually enter 100, then select AND as an additional criteria, then manually enter 120, then click OK. This results in the variable vChoice, containing the following TEXT value: WHERE customer.CustID BETWEEN 4 AND 20 So the whole thing would look something like this: CHOOSE vchoice FROM #WHERE IN customer SET VAR vcount INTEGER = 0 SELECT COUNT (*) INTO vcount IND vin0 FROM customer &vchoice IF vcount > 0 THEN BROWSE * FROM customer &vchoice ELSE PAUSE 2 USING 'No Matching Records Found!' ENDIF ----- Original Message ----- From: "Jim Belisle" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Saturday, April 11, 2009 1:23 PM Subject: [RBASE-L] - Re: Button fro the Where builder Mike, Thanks for your reply. I am rather clumsy at using the functions in RBASE so I often can't quite figure out how to connect my sentences in the EEP's I am writing. I understand the choose clause you mentioned below. Now how do I relate the variable that contains the WHERE clause to the form? CHOOSE vchoice FROM #WHERE IN DistQuotes BROWSE USING DistQuoteScroll All I get with the above is all the quotes in the table. Jim -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of MikeB Sent: Saturday, April 11, 2009 8:44 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Button fro the Where builder Jim, It is a part of the Choose action.. So, In your EEP: choose vVarName from #WHERE in TableView ...... vVarName will contain the Where Clause. ----- Original Message ----- From: "Jim Belisle" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Saturday, April 11, 2009 8:28 AM Subject: [RBASE-L] - Button fro the Where builder Is there a code I can write within an EEP (on click) that will bring up the where builder for a specific report or form? I want people to have access to the Where builder so they can check on quotes based on numerous fields. Jim
