Sorry Gary, my mistake... in my haste I thought I saw rrateid there
twice <blush>.
What you might try is building a column in your view that does the
concatenation and formatting that you want and do the choose
from there. Also; I don't think it will make any difference, but you
don't need to ctxt the return var as choose always returns text
> but when you have the id in the return location it
> appears to use it in the distinct as well. (??)
I've never noticed this, but may not have stumbled over it yet either.
Ben Petersen
On 3 Jul 2001, at 10:48, Gary L. Winzeler wrote:
> 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
>
>
