Subject Re: [firebird-support] Best Way to Pass a Comma Delimited List of Numbers?
Author Alexandre Benson Smith
Steve Miller wrote:
> We are porting a fair number of stored procedures from SQL Server to
> Firebird. A fair number of these procedures take an input parameter, a
> comma delimited list of integers with a type of NTEXT. (Why the system
> does that would take some explanation, but in short, they are a list
> of object IDs. We have object data mapped to the relational database.)
> I am looking how to pass such a comma delimited list of IDs to a
> Firebird procedure. The VARCHAR(n) data type is really too small for
> the comma delimited list. Is a blob the way to go? If so, what might
> the code look like? Blobs have a somewhat daunting amount of
> documentation for a newcomer.
> Steve

you could pass it inside a varchar (that holds up to 32k data), if it's
to small for you.. then I believe you will hit another limitation... the
number of values inside an IN clause is 1400 (plus something) or the
maximum SQL statement size.

I think you should re-think your approach, look on the messages from the
last week, it was far debate.

see you !

Alexandre Benson Smith
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil