Subject Re: Stored procs and array parameters...
Author Svein Erling Tysvær
Where is that array of strings located and what should the stored
procedure do with it? In some cases it may be possible to do something

SELECT sp.outputparemeter
FROM tablewithstrings tws
LEFT JOIN storedprocedure(tws.stringfield) sp on (1=1)

but this of course doesn't work if you, say, want to do some
aggregation like concatenating the fields in the stringlist.


--- In, "Greg At ACD" wrote:
> Hi all,
> I realize that in FB 1.5 there is no support for passing arrays as
> parameters to stored procedures (e.g. array of integers or strings).
> Is this something that is being considered for a future release? Any
> alternatives to this that may work?
> One possiblity would be to pass in a comma separated string to the
> stored proc, and have the stored proc parse it, but I keep thinking
> that having the calling application generate this and have the
> stored proc parse it would take more time than its worth :( .
> In one situation, my client application (VC++, SQLAPI interface)
> calls a particular stored procedure once for each element in an
> array of strings. Of course, each call has some overhead (create
> SQL, prepare (parse) over network, execute, package results, send
> back over nework, repeat), so if I could call an SP that would take
> the array of strings as input, it would likely be more
> efficient... :)
> thx!
> Greg