Almost anything, I still cannot get the values to come up where I only have one of each (#values for distinct). On the current update Dbedit combo box and list box have checkbox's that will let you **Display Distinct** values. I do appreciate everyone's assistance, I am sure we will figure it out. Thanks, Fran Yount [EMAIL PROTECTED]
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Dawn Oakes Sent: Friday, February 04, 2005 7:16 AM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: DBedit box /popup menu So what I'm gathering is that anything I can do in a CHOOSE, I can do in a popup. A popup is just a choose statement anyway (DUH). As Albert said, my reaction is Why didn't I think of that? -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Javier Valencia Sent: Thursday, February 03, 2005 6:15 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: DBedit box /popup menu Dawn: Not only you can do that but a lot more. For example, I have a pop up that display the equipment code and description as follows: File: equip_file Pop-up type: columns with expression Columns returned: equip_code Under Menu values I have: ( LJS(equip_code, 20) + LJS(equip_desc,40) ) In the body of the WHERE clause I have: WHERE equip_type <> 'SAL' ORDER BY equip_code ASC TITLE 'Equipment Code Description _' CAPTION 'Select Equipment where radio is installed ...' LINES 20 OPTION LIST_FONT_NAME Courier New | TITLE_FONT_NAME Courier New | TITLE_FONT_COLOR BLUE | CAPTION_FONT_NAME Courier New Note: I use a bunch of blank spaces and a "_" at the end of the TITLE definition after "Description" in order to line up the header with the data. As you can see, there are a lot of things that can be done with the pop-up; by changing the fonts and colors, you can get pretty fancy pop-ups. Javier, Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln, Suite #14 Olathe, Kansas 66062-4578 Office (913)829-0888 Fax (913)649-2904 Cell (913)915-3137 ================================================ Attention: The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from all system and destroy all copies. ====================================================== -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Dawn Oakes Sent: Thursday, February 03, 2005 5:03 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: DBedit box /popup menu Well I'll be a.... I've always created a view and based my popup on the view. It didn't occur to me until just now to do a group by right in the popup where clause. I don't know why, I guess I just got used to doing that. ...something new everyday -----Original Message----- From: Albert Berry [mailto:[EMAIL PROTECTED] Sent: Thursday, February 03, 2005 5:44 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: DBedit box /popup menu Check you SELECT syntax, and add the GROUP BY clause to your choose popup WHERE <if any> GROUP BY <column> ORDER BY <if different than the group by> --- Fran Yount <[EMAIL PROTECTED]> wrote: > I am trying to figure out how to write the expression in the Dbedit > popup menu to show distinct values. I could write and "eep" but I > would prefer not to. I am new to the Rbase developer's page so any > help or direction would be greatly appreciated. > > Sincerely, > > Fran Yount > [EMAIL PROTECTED] > > ===== Albert Berry Management Consultant RR2 - 1252 Ponderosa Drive Sparwood BC, V0B 2G2 Canada (250) 425-5806 (250) 425-7259 (708) 575-3952 (fax) [EMAIL PROTECTED]
