Subject | In firebird store_procedure IN clause is not giving the desired result |
---|---|
Author | mauleen2001 |
Post date | 2007-06-04T09:40:59Z |
Hello,
I am having one problem in store-procedure. I am passing a variable
value as a input parameter in a store-procedure and that value is used
in following statement (:varValue and its value is 'FL000001','FL000003')
Delete fileid from container where fileid in (:varValue)
I can not get the desired result.
If i use the hard coded value then it works fine. for ex.
Delete fileid from container where fileid in ('FL000001','FL000003')
What could be the problem?
I am having one problem in store-procedure. I am passing a variable
value as a input parameter in a store-procedure and that value is used
in following statement (:varValue and its value is 'FL000001','FL000003')
Delete fileid from container where fileid in (:varValue)
I can not get the desired result.
If i use the hard coded value then it works fine. for ex.
Delete fileid from container where fileid in ('FL000001','FL000003')
What could be the problem?