Hi
Using FB1.5.3 I have a problem with one procedure.
I have define 2 parameters in system_parameters table, to identify category
and group of product.
I have a procedure to return all product id in parameter category and
group.
Values are:
CAT=1
GRP=3,4 (this means group 3 and 4)
SQL in procedure is:
for
Select productid_id from SYS_PRODUCTS where
cat in (SELECT PVALUE from SYS_Parameters where PCODE='CAT') and
grp in (SELECT PVALUE from SYS_Parameters where PCODE='GRP')
into :product
do
suspend;

Procedure returns nothing. If I change parameter grp to 3 or 4 is working as
expected.
I have tried to cast grp as varchar and returns noting.

How can I make this work?
TIA,
Paul


[Non-text portions of this message have been removed]