Вот вопрос перед переходом на FB
Так писать нельзя в 1.5.3 (имеется в виду (p.id_group in (select id from
recurs_groups(:id_groups))))
А можно ли уже так писать в FB 2.0 ?
select p.name,p.fullname,p.description,
pc.rest,pc.price,pc.price_delivery,p.price_retail,p.price_retail_val,
s.id_store, s.name, d2.date_docum, d2.id_currency, d2.rate
from sp_products p, product_cards pc, stores s, docum_items di2,
documents d2
where (p.id_product = pc.id_product)
and (p.id_group in (select id from recurs_groups(:id_groups)))
and ((pc.id_store=:id_stores) or (:id_stores is null))
and (pc.id_store = s.id_store)
and (pc.rest<>0)
and (pc.id_docitem = di2.id_docitem)
and (di2.id_docum = d2.id_docum)
