Frank:
The column
name in the GROUP BY statement must be one of the columns in the table used in
the “Table/View Name” at the top. I believe that that column cannot be NOTE or
varchar. What are your other settings?
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]On Behalf Of [EMAIL PROTECTED]
Sent: Thursday, February 03, 2005
7:47 PM
To: RBG7-L Mailing List
Subject: [RBG7-L] - Re: DBedit box
/popup menu
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 <[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
