N/ODBC - Flow Filter not working

marco.morreale

On the Item table I created a flow filter named "EndDateFilter" fo type Date.

Then I created a flowfield named "Esiste Listino Italia" as follows:

Exist("Sales Price" WHERE (Item No.=FIELD(No.),Sales Code=CONST(ITALIA),Ending Date=FIELD(EndDateFilter)))


My odbc query is:

SELECT "No." FROM ITem WHERE {pred SetFlowFilter, 'Item', 'EndDateFilter', '>050407'} AND "No." = 'BR1A01A003' AND "Esiste Listino Italia"=1

it returns always the same result as

SELECT "No." FROM ITem WHERE AND "No." = 'BR1A01A003' AND "Esiste Listino Italia"=1

(without the pred statement)

I mean that every flowfilter setting though the sintax in brackets is ingored.

How does it work?

My purpose is to retrive all items with a valid sales price.

Marco Morreale

gulamdastagir

nodbc doesnt work SQL server,you can use Microsoft SQL ODBC driver.But even this does not calculate the Flowfields.