I do not know why this has me so confused but it does. So what would I put in the pop up type , menu values and where clause to get the values to come up distinct?
Fran -----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]
