Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General Discussion » View Thread |
Messages 1 to 4 of 4 total |
Custom Function parameters |
Mon, Feb 6 2006 9:10 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Can anyone suggest a way of passing a list to be used in an IN statement as a custom function parameter?
eg inside the custom function I want to build a statement like WHERE Field IN (FunctionParams[3]) Roy Lambert |
Mon, Feb 6 2006 11:21 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< Can anyone suggest a way of passing a list to be used in an IN statement as a custom function parameter? eg inside the custom function I want to build a statement like WHERE Field IN (FunctionParams[3]) >> Why not simply as a comma-delimited string ? -- Tim Young Elevate Software www.elevatesoft.com |
Mon, Feb 6 2006 12:30 PM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
><< Can anyone suggest a way of passing a list to be used in an IN statement >as a custom function parameter? > > eg inside the custom function I want to build a statement like > > WHERE Field IN (FunctionParams[3]) >> > >Why not simply as a comma-delimited string ? Hmm does IN work on a comma delimited string? I'll go and suck it Roy Lambert |
Tue, Feb 7 2006 11:00 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< Hmm does IN work on a comma delimited string? I'll go and suck it >> Sure, as long as you're taking the string and building it into the SQL text dynamically and not trying to use it as a parameter. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Wednesday, April 17, 2024 at 10:35 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |