Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 5 of 5 total |
Array parameters for IN |
Wed, Jun 20 2007 3:52 AM | Permanent Link |
Roy Lambert NLH Associates 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 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 AM | Permanent 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 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Harry
Almost there 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 AM | Permanent 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 > > 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 > |
This web page was last updated on Friday, September 20, 2024 at 05:39 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |