Albert's example forces Distinct.. ----- Original Message ----- From: "Fran Yount" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Thursday, February 03, 2005 7:37 PM Subject: [RBG7-L] - Re: DBedit box /popup menu
> 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] >
