Re: how to pass array in stored procedures

Article View: borland.public.interbase.sql

Article #11085

Back to borland.public.interbase.sql Previous Next

#11085

From: Craig Stuntz TeamB
Date: Fri, 20 Dec 2002 22:07

17 lines
1659 bytes

In article <3e038c05$1@newsgroups.borland.com>, podian@yahoo.com says...
> one idea is to pass an array of values and create a procedure to do 'OR'.

	Arrays are almost totally unsupported in procs, sorry.
> 
> any other ideas?
> 
	You can put the values in the table and JOIN them into your SELECT.  
This will probably produce a more efficient query anyway.

	-Craig

-- 
Craig Stuntz [TeamB] � Vertex Systems Corp. � Columbus, OH
Delphi/InterBase Weblog : http://delphi.weblogs.com
InterBase Perf. Monitor : http://delphi.weblogs.com/IBPerformanceMonitor
InterBase PLANalyzer 1.1: http://delphi.weblogs.com/IBPLANalyzer

Technical Details

Message-ID: <MPG.186d5ec620e6746498a477@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!newsswitch.lcs.mit.edu!newsfeed.cwix.com!opentransit.net!newsfeed.icl.net!newsfeed.fjserv.net!lnewspeer00.lnd.ops.eu.uu.net!emea.uu.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <3e038c05$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII
X-Google-Thread: 114a0e,8a6a27987832b112
X-Google-Attributes: gid114a0e,public
X-Google-ArrivalTime: 2002-12-20 14:09:19 PST
From: Craig Stuntz [TeamB] <cstuntz@nospamplease.com  (but use vertexsoftware to email)>
Newsgroups: borland.public.interbase.sql
Subject: Re: how to pass array in stored procedures
Date: Fri, 20 Dec 2002 17:07:52 -0500
Message-ID: <MPG.186d5ec620e6746498a477@newsgroups.borland.com>
References: <3e038c05$1@newsgroups.borland.com>
Organization: Vertex Systems Corporation
X-Newsreader: MicroPlanet Gravity v2.60
NNTP-Posting-Host: 65.86.87.242
X-Trace: newsgroups.borland.com 1040422077 65.86.87.242 (20 Dec 2002 14:07:57 -0800)
Lines: 17
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!newsswitch.lcs.mit.edu!newsfeed.cwix.com!opentransit.net!newsfeed.icl.net!newsfeed.fjserv.net!lnewspeer00.lnd.ops.eu.uu.net!emea.uu.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message