Subject | Question |
---|---|
Author | hans@hoogstraat.ca |
Post date | 2001-10-02T04:46:47Z |
How do I resolve the fact that I can't pass '1,2,3' in NUMBERS
CREATE PROCEDURE TEST (NUMBERS VARCHAR(30))
RETURNS ( NAME VARCHAR )
AS
BEGIN
FOR SELECT NUMBER FROM TABLE
WHERE NUMBER IN ( :NUMBERS )
INTO :NAME DO
SUSPEND;
END
but can say
WHERE NUMBER IN ( '1,2,3' )
Best Regards
Hans
CREATE PROCEDURE TEST (NUMBERS VARCHAR(30))
RETURNS ( NAME VARCHAR )
AS
BEGIN
FOR SELECT NUMBER FROM TABLE
WHERE NUMBER IN ( :NUMBERS )
INTO :NAME DO
SUSPEND;
END
but can say
WHERE NUMBER IN ( '1,2,3' )
Best Regards
Hans