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
