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
>
> WHEREGROUP BY ORDER BY > 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, V
