Hi,

I want to use a "Select List" as Select-Param for a Stored Procedure.

Example:
------------------------------------------------------
BEGIN

FOR SELECT RELID AS VID From DIRECTORYTABLE
WHERE (RELID in (Value1, Value2, Value3)

INTO :VID DO SUSPEND;

END
------------------------------------------------------

It should be
------------------------------------------------------
BEGIN

FOR SELECT RELID AS VID From DIRECTORYTABLE
WHERE (RELID in :VALUELIST)

INTO :VID DO SUSPEND;

END
------------------------------------------------------

But I don't know what typ I can use to passthrou a valueliste to a
stored procedurce. I try Varchar, But this doen't work.

Have anybody an idea?

with best regards

Nils Bödeker

--
*--------------------------------------------------------*
| Nils Boedeker VERLAG EUGEN ULMER |
| Bürgerwohlsweg 60B Datenbanken und IT-Entwicklung |
| D-28215 Bremen -------------------------------------|
| Germany Tel/Fax: +49 (0) 421 3795-020/-021 |
| Mobilfunk: +49 (0) 172 7468066 |
|--------------------------------------------------------|
| eMail:nboedeker@... | eMail:info@... |
|--------------------------------------------------------|
| http://www.ulmer.de | http://www.nbsoft.de |
*--------------------------------------------------------*