ODBC - passing parameter into flowfilter

smatijev

When I want to set date flowfilter on Item table I have to make the following SQL query through Microsoft Query:

SELECT Item.No_, Item.Description, Item."Sales (LCY)", Item."Sales (Qty_)"
FROM Item Item
WHERE {pred setflowfilter, 'Item', 'Date filter', '010106..310106'}
ORDER BY Item.No_

Problem is that I can't set this date range dynamically because when I try to replace string '010106..310106' with ? I get following error:
Parameters are not allowed in queries that can't be displayed graphically.

If I try this with "normal" field:

SELECT Item.No_, Item.Description, Item."Sales (LCY)", Item."Sales (Qty_)"
FROM Item Item
WHERE (Item.No_=?)
ORDER BY Item.No_

then there isn't any problems and I can pass parameter from Excel to Microsoft query.
Any suggestions for some work-around :?:

kcoo03

Hi all,

Getting this same problem...

Does anyone have any ideas how to solve this or can point me to some resources where I can find out more about the "pred setflowfilter" mentioned?

Thanks,