Helen,

In my role as the Feature Request list 'maintainer', I have made it my
policy not to filter-out any *reasonable* request that is made on the
various lists.

Now of course, reasonable, is in the eye of the beholder. Fortunately,
with 7 years experience using FB/IB and following the FB/IB lists, I
think I have a very good sense of what is reasonable.

Question of priority, current feasibility or ultimate 'validity' of a
request is not part of the equation which determines what gets added to
the list. These are questions for the devel list and developers
themselves.

Accordingly, Mark & Swein's suggestion met the 'reasonable' mark. And
so does your's -- I will be adding it to the list.


Sean

> -----Original Message-----
> From: Helen Borrie [mailto:helebor@...]
> Sent: Thursday, November 07, 2002 10:55 PM
> To: ib-support@yahoogroups.com
> Subject: RE: [ib-support] Can you use ".." in IN statement?
>
>
> At 06:31 PM 07-11-02 -0500, Sean Leyne wrote:
> >Mark and Svein,
> >
> > > From: Mark Patterson [mailto:mpatterson@...]
> >
> >
> > >
> > > WHERE KeyNum IN (10, 13..20, 22.35, 41, 43)
> > >
> > > Nothing like succinctness! But it must be an MS SQL
> > > extension. I hope it gets included in the next SQL
> > > standard.
>
> I don't! I think it's a very short-sighted feature and I'd
> much prefer for
> it to stay as now, viz.
>
> where something IN (set of individual values of the same size
> and type)
>
> The enhancement I would love to see is the ability to
> parameterise the
> items inside the comparison set. I have difficulty seeing
> how this could
> be done if it were allowable to include a set as a comparison value.
>
> I can do this already:
>
> where something IN (10.00, 22.35, 41.00, 43.00)
> or something BETWEEN 13.00 and 20.00
>
> but how often have I wanted to pass values for a set to a SP,
> so that my SP
> could have
>
> where something IN (arg1, arg2, arg3, arg4)
>
> iow, I don't think you get much bang for your buck being able
> to include a
> set as if it were a comparison value...especially if it would
> preclude
> adding a much more powerful enhancement.
>
> heLen
>
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~-->
> Get 128 Bit SSL Encryption!
> http://us.click.yahoo.com/JjlUgA/vN2EAA/kG8FAA/67folB/TM
> --------------------------------------------------------------
> -------~->
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
>
>
>