| Subject | Re: Convert varchar argument to an integer array |
|---|---|
| Author | Paul R. Gardner |
| Post date | 2007-08-31T13:55:37Z |
If you have a varchar variable of "(1,2,3)" I'd simply use the EXECUTE
STATEMENT route:
FOR EXECUTE STATEMENT SELECT FIELD FROM TABLE WHERE ID IN ||
MyVarCharVariable INTO :RESULTVARIABLE DO ...
[Non-text portions of this message have been removed]
STATEMENT route:
FOR EXECUTE STATEMENT SELECT FIELD FROM TABLE WHERE ID IN ||
MyVarCharVariable INTO :RESULTVARIABLE DO ...
[Non-text portions of this message have been removed]