Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 5 of 5 total
Thread Array parameters for IN
Wed, Jun 20 2007 3:52 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Tim

Is there an intention to add array parameters for IN's? If so is there a timescale?

Roy Lambert
Wed, Jun 20 2007 7:12 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Roy,

<< Is there an intention to add array parameters for IN's? If so is there a
timescale? >>

Arrays and row values will be added at some point, but I don't have a
timeframe yet.

--
Tim Young
Elevate Software
www.elevatesoft.com

Thu, Jun 21 2007 7:55 AMPermanent Link

"Harry de Boer"
Roy,

Out of curiousity: what do you mean by 'array parameters for the in clause',
and what could be the use/benefits. I guess you mean something else then IN
(1,2,3,4), because you can do that now already.

Regards, Harry

"Roy Lambert" <roy.lambert@skynet.co.uk> schreef in bericht
news:87C398B7-DE2B-4DFE-8F69-F55C184F48C8@news.elevatesoft.com...
> Tim
>
> Is there an intention to add array parameters for IN's? If so is there a
timescale?
>
> Roy Lambert

Thu, Jun 21 2007 8:26 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Harry


Almost there Smiley

So I can do something like

Field IN (:arrayparam)

Which would allow me to prepare the statement and thus be a bit faster. At present I have to use StringReplace which means the statement can't be prepared and so its not as fast as it might be.

Roy Lambert
Thu, Jun 21 2007 10:02 AMPermanent Link

"Harry de Boer"
Roy,

Ah.. I see. Thanks. Nice to know.

Harry

"Roy Lambert" <roy.lambert@skynet.co.uk> schreef in bericht
news:E38B4241-928E-48E9-BF77-4966DC8D126B@news.elevatesoft.com...
> Harry
>
>
> Almost there Smiley
>
> So I can do something like
>
> Field IN (:arrayparam)
>
> Which would allow me to prepare the statement and thus be a bit faster. At
present I have to use StringReplace which means the statement can't be
prepared and so its not as fast as it might be.
>
> Roy Lambert
>

Image