Yes, that is what I'm doing - just showing the descriptive data and trying
to return the id, but when you have the id in the return location it
appears to use it in the distinct as well. (??)
Am I doing something wrong here??
GARY
At 10:31 AM 7/3/01 +0100, you wrote:
>Gary,
>
>I know it's obvious, but is it a requirement to show the ID... could
>you just base your choose on the descriptive data and just return
>the ID?
>
>Ben Petersen
>
>
>On 3 Jul 2001, at 10:04, GARY Winzeler wrote:
>
> > I am trying to do a choose and limit the rows returned by from a
> view. The
> > view is a two table view from Plans (pplanid pri key) and Rates (rrateid
> > pri key).
> >
> > each plan has many rates and the rates have tiers which is in the rates
> table.
> >
> > CHOOSE vxrrateid FROM #VALUES FOR DISTINCT +
> > (LJS(pname,14) & LJS(ptosdesc,45) & LJS(ptype,8) & 'Tier' &
> CTXT(rtier)), +
> > (CTXT(rrateid)) +
> > FROM vwplans +
> > WHERE rcarid = .vrcarid +
> > AT 18,28 +
> > TITLE 'Select a Plan (Esc when Done)' +
> > CAPTION 'Plans' +
> > LINES 19 FORMATTED
> >
> > as you can see I am trying to return the rrateid which is the primary key
> > in the rate table, but with this in the choose it returns all records in
> > the view because rrateid is unique. Is there a way to limit the rows
> > distinct for each plan and tier then return the rrateid?
> >
> >
> > THANKS
> > GARY
> >
> >
Regards,
Gary L. Winzeler
DAQtech, Inc.
Data Acquisition Technology
<mailto:[EMAIL PROTECTED]>
<http://www.daqtech.com/>
Office 408-847-4800
Fax 408-847-4097
Cellular 408-483-7739
