Fran, can you cut and paste your popup and also the table/view definition? We will be able to tell you what the problem is. This error message normally means that you have two or three columns with no function on one of them, and not grouping by all columns listed that have no functions. Functions are SUM(), AVE(), COUNT() etc.
--- [EMAIL PROTECTED] wrote: > Any time I try to put the Group by in the where box I get and iIllegal column > in statement, when > I try to use it. > Fran > > -------------- Original message -------------- > > > Frank: > > This is what you do: > > In the Pop-up Menus window > > Table/View Name: select the table from where you want the values to come > > from > > Pop-up type: select whether you want to display a single column, more that > > one column or an expression. If you select single column, the return column > > will be displayed by default; if you select multi column, you will be > > prompted to select more than one column. > > Column returned: the column, which value you want in the field. The column > > that is returned does not have to be the same as the column(s) displayed. > > For example you may want to display an employee last name and first name > > but > > you want to return the SSN; so, when you click on the employee name in the > > pop up, the Social security number for that employee will be displayed in > > the DBEdit field. > > Menu Caption: Whatever you want to display above the values > > Number of Lines: How many lines you want to display > > If you want to display unique values for a column, then, on the big box > > under WHERE Clause type: > > GROUP BY your_column_name > > Notice that there is no "WHERE" typed. For example if you want to display > > the state code from a file in which the state_code is repeated and you want > > to display just one occurrence of each, the you would type: > > GROUP BY state_code > > This will display just one line for each state_code and will also sort the > > data by state_code. > > I hope this is what you are looking for; if not, let us know and we will > > make sure that you get your pop-up going... > > 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 Fran Yount > > Sent: Thursday, February 03, 2005 6:38 PM > > To: RBG7-L Mailing List > > 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 GROUP BY ORDER BY > by> > > > > --- Fran Yount 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] > > ===== 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]
